updating dataset from datagrid

[Jim]

I have a dataset-bound datagrid and, when the user adds a row to the
datagrid and fills it with the data, I'd like to be able to update the
dataset (with the newly-added row) and then the database table (also with
the newly-added row).

Normally I'd do it with a DataAdapter method call but the dataset is
returned from within another class (I don't declare the dataadapter here).
What can I do?

Thanks.

Thanks.

[William Ryan]

Jim:
Think about this analogy....I can't spend more than $500.00 a month on all
of my living expenses. However, I want to buy a 2003 Porsche. Those two
requirement don't play well together. Fortunately, you can look at the
DataSet GetChanges and then manually write a ton of code to
update/insert/Delete. Or, you can declare your DataAdapter locally, and set
a property in your class that maps to the original dataAdapter.
Fortunately, you can have it both ways.

I'm going to ruffle a few feathers here, but if you are using disconnected
methodology.... don't let the adapter leave scope and lose its references if
you need to update with it.

If this is too vague, let me know and I'll walk you through it.

Cheers,

Bill
"Jim" <NA> wrote in message news:OH******** ******@TK2MSFTN GP09.phx.gbl...

I have a dataset-bound datagrid and, when the user adds a row to the
datagrid and fills it with the data, I'd like to be able to update the
dataset (with the newly-added row) and then the database table (also with
the newly-added row).

Normally I'd do it with a DataAdapter method call but the dataset is
returned from within another class (I don't declare the dataadapter here).
What can I do?

Thanks.

Thanks.