Use ASP.net DataGrid with temporary table (from Stored Proc)

Hi,

I have a datagrid that is bound to the results of an Stored Proc (a temp table), in code. Something like:

DataView _sendTo;
SqlDataSourceMatches.SelectCommand = EXEC get_matches 1, 2, 3    
// The S/P returns multiple data sets
DataSet ds = ((DataView)SqlDataSourceMatches.Select(DataSourceSelectArguments.Empty)).Table.DataSet;
        _sendTo = new DataView(ds.Tables[0]);
GridViewMatches.DataSource = _sendTo;
GridViewMatches.DataBind();

The datagrid has a tick box at the start of each row to determine if the row should be 'processed' or not. The store proc defaults each row to true (value of 1 for the BIT).

When users un-select the tickboxes and click next, they all default back to TRUE again. I guess this makes sense, since I am not editing the temp resultset.

How can I ensure that the users options to process a row or not are **persisted between each page refresh? ** In effect, I want to 'edit' multiple rows of the DataView that the grid is bound to.

Thanks a lot for any help (or a better way to do this)

ansaurus

tags:

views:

answers:

Use ASP.net DataGrid with temporary table (from Stored Proc)

related questions