Dataset / DataAdapter Quesiton..!

[jcb1269]

I'm loading a grid with records from table1. Then I'm changing some of the
records in the grid. What I want to do is load those records into a dataset
or whatever is recommended and then update table1 with the new information.

How can I do this? What's the best way?

Thanks in advacnce...!

Jim

[Scott M.]

Re: Dataset / DataAdapter Quesiton..!

In the UpdateCommand event handler of the grid, take the data from the input
fields of the grid and modify the corresponding fields for the correct
corresponding row in the DataSet. Call the DataBind method of the DataGrid
to refresh the grid and then call the Update method of your DataAdapter to
update the original data source.


"jcb1269" <jcb1269@discus sions.microsoft .com> wrote in message
news:30F35361-A383-411F-B9AC-025911EF2BAE@mi crosoft.com...[color=blue]
> I'm loading a grid with records from table1. Then I'm changing some of
> the
> records in the grid. What I want to do is load those records into a
> dataset
> or whatever is recommended and then update table1 with the new
> information.
>
> How can I do this? What's the best way?
>
> Thanks in advacnce...!
>
> Jim[/color]