Regenerating a Datagrid

[Shahir A. Ahang]

All,

I am wondering if there is a way to regenerate a datagrid which has already
been bound to a dataset WITHOUT having to re-query the data source.

In my page, I have a drop-down control which is populated through a SQL
query. Once the user selects a value from the drop-down, the datagrid is
generated. I have included in the datagrid a ButtonColumn to remove
unwanted rows:

<asp:ButtonColumn CommandName="Delete" HeaderText="Remove"
ButtonType="LinkButton" Text="Remove" />

Now, when the user clicks on "Remove" for any row in the datagrid, I simply
want to remove the row from the datagrid and regenerate the datagrid without
having to make another query to the data source. Essentially I want
manipulate the existing datagrid object and regenerate it without having to
re-query the database.

Any assistance would be greatly appreciated.

Shahir

 

[Elton Wang]

Save the query result, e.g. DataTable, in Session. The retrieve it from
Session and cast to datatable (or whatever type it is).

HTH