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


"Shahir A. Ahang" <shahir@nospam.com> wrote in message
news:2ca3b$43418895$c61dbf94$725@msgid.meganewsser vers.com...

> 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
>
>