can someone help me with the follwing

i can able display the ms access table in datagridview control of vb 2005 now i want to update the table values from vb.im using ms access 2007. and by using oledb connection statements i hv connected the access database


do u have any suggestions that how can i update the ms access table ..

Recommended Answers

All 3 Replies

Like you insert or retrieve the data, just change the SQL command, read in OleCommand

after populating the textboxes with d old values we can modify and wil do updation query, that is fine .. but before this how can i select the particular record to update and to populate the old values in the textboxes.. that is wat my pblm,

can sum1 help me out

First you have ID for the row, get the data using the ID, then update the data using the ID... so simple!

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.