ASP.NET SqlDataSource cached collection

Question

Is it possible to programmatically access items in sqldatasource once they are loaded? Context: sqldatasource is binded to list of checkboxes. When submitted, I have id of selected item, but I also need other information. So if I could acces loaded items in SqlDataSource that would suffice.

i know this is not very clear, I'm new to asp.net and it's so counter-intuituve.

jdavies · Accepted Answer · 2011-09-07 00:36:36Z

1

As long as the sqlDataSource has been setup to Cache the data (DataSourceMode="DataSet" EnableCaching="True") (See Caching Data with the SqlDataSource Control) then you can select cached items using the sqlDataSource in code like so:

DataView dataView = (DataView)sqlDataSource.Select(new DataSourceSelectArguments());
DataTable dataTable = dataView.ToTable();

The DataSourceSelectArguments class provides a means to specify the SortExpression amongst other things.

Hope this helps.

answered Sep 7, 2011 at 0:36

jdavies

12.9k3 gold badges35 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

ASP.NET SqlDataSource cached collection

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related