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

--
Miha Markic [MVP C#] - RightHand .NET consulting & software development
miha at rthand com
www.rthand.com

"pnp" <pnp.at.softlab.ece.ntua.gr> wrote in message
news:e6**************@TK2MSFTNGP10.phx.gbl...

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

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

"Tony Almazan" <al******@noa.nintendo.com> wrote in message
news:eu**************@tk2msftngp13.phx.gbl...

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.