Datagrid Update DB?

[pnp]

Hi all,
I have a datagrid that connects to a DataSource through ODBC and I can't
seem to make a datagrid cell update the database with the new value, when I
edit that cell... How can I do this?

Thanks in advance,
Peter

 

[Miha Markic [MVP C#]]

Hi,

You'll have to use ado.net OdbcDataAdapter.Update method on source table.
You might read about ado.net and database access in .net help files...

 

[Tony Almazan]

What kind of data source is it? Is it a Dataset? If its a Dataset then you have to manually get the changes from the datagrid and then update the Dataset. After you do this then use the adapter to call the update method with the Dataset.

 

[William Ryan eMVP]

What kind of data source is it? Is it a Dataset? If its a Dataset then

you have to manually get the changes from the datagrid and then update the
Dataset.

Actually, you can just call Update directly on the underlying table(s)
calling
dataAdapter1.Update(ds.Tables[0])
dataAdapter2.Update(ds.Tables[1])

etc
After you do this then use the adapter to call the update method with the
Dataset.