Member Avatar for Muhasin

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?

  • 3 Contributors
  • 2 Replies
  • 94 Views
  • 3 Days Discussion Span
  • Latest Post Latest Post by xtianenikkian
Member Avatar for debasisdas

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
Member Avatar for xtianenikkian

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.