VB datagrid and db

  • Thread starter Thread starter reta reta
  • Start date Start date
R

reta reta

hi
I was wondering if someone could help me. I am developing a form in vb
which has a MS Access db running behind it. on the from i have a
datagrid which retrieves the information from that db and outputs it to
the screen, therefore it is a dynamic datagrid. My problem is there is a
column with in the datagrid which ebables the user to enter in the value
1, which means they have pick that row to be stored in the db, however i
dont know how to do to the next row in the datagrid to store this in the
db.
That is having multiple rows with 1's next to then and storing them in
the db.
Please can someone help me out there
Reta
 
Depends on what that row is. If it's a key value, then you aren't going to
be able to do what you want to do. Let's think positive though and assume
you can enter that information. With the datagrid bound to the dataset, use
the currencymanager object to keep it all in synch. Add a new row to the
datatable, add values to those columns, then use the dataadapter to submit
the Insert to the database.
 
Back
Top