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.
Jump to Post
You 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).
All 5 Replies
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, learning, and sharing knowledge.