I am using visual basic 6. I need to update my database table which i created for the form. I am using ADobc database. How can i update the database by using the coding?
Muhasin
0
Newbie Poster
Recommended Answers
Jump to PostADODC is not a database, it is a control to connect to database.
use ADODB and try this code
cn.begintrans ' cn--adodb connection object cn.execute "your update command goes here" cn.committrans
All 2 Replies
debasisdas
580
Posting Genius
Featured Poster
ADODC is not a database, it is a control to connect to database.
use ADODB and try this code
cn.begintrans ' cn--adodb connection object
cn.execute "your update command goes here"
cn.committrans
xtianenikkian
1
Light Poster
or also try
adodb.refresh
after you execute a SQL code in the datagrid
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.