Do you mean you're using
to get your data? If so, you really should learn using SQLDataAdapter or Entity Framework or anything other than SqlDataSource. If you want something quick/basic, SqlDataSource works but as you do more stuff, it's really limited.
But here's one way to get the data then store in a session as a DataTable to work with.
Note: This is with C#
Code:
<asp:SqlDataSource />
But here's one way to get the data then store in a session as a DataTable to work with.
Code:
DataView dv = new DataView();
DataTable dt = new DataTable();
dv = mySqlDataSource.Select(DataSourceSelectArguments.Empty);
dt = dv.ToTable();
Session["products"] = dt;
Note: This is with C#






