I have a form with a recordset which is filtered on some controls on the form. In the code behind page I want to loop through the records as filtered on the form. I can set up another SqlDataSource and refilter it on the same controls, but I'm wondering if there's an easier way just to select the existing recordset as filtered.
Thanks,
Ed
edfinley
0
Newbie Poster
Recommended Answers
Jump to PostYou can create a custom class to hold a row of data then create a collection to hold all of the custom objects. Then you can traverse the data in any manner you wish without additional trips to the database (depending on the volume).
Jump to Posthow about using sqlcommandbuilder and using dataset and data adapter
using a datarow, you can loop through its row.
All 5 Replies
thines01
401
Postaholic
Team Colleague
Featured Poster
anthonyjpv
6
Junior Poster in Training
thines01
401
Postaholic
Team Colleague
Featured Poster
edfinley
0
Newbie Poster
mani-hellboy
-10
Junior Poster in Training
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.