Update DB2 Table Using ODBC.net -
05-14-2004
, 01:30 PM
Hello,
I am working on a VB.Net application accessing DB2 using ODBC classes.
I am able to connect to the DB2 database, fill a dataset and bind it to a
datagrid and its working fine.
But this is what I need help with....
The very first column of the rows in the datagrid have a checkbox. When the
checkbox is checked by the user (or when multiple checkboxes are checked), I
need to mark those rows (Update one row or multiple rows) as "Processed".
If anyone has done an Update of a table in DB2 using ODBC in VB.Net or C#,
please send me a sample of how it is done.
One other thing I am confused about is when the user has selected multiple
rows to be updated, can I connect, open and apply updates to multiple rows
and then close the database, or do I need to open, apply update and close
database for each row ?? Sorry, if this sound naive, I am a total newbie.
Please also send me any websites relating to ODBC.Net that you might know
of.
Thanks in advance for your help.
Mona |