Vb datagrid query to the data store to another database data sheet after


Dim Con As New ADODB. Connection 'definition ADO object
Dim the Rs As New ADODB. You
Con. The ConnectionString="driver=SQL Server; Server=192.168.1.127, 1433; Uid=sa; The PWD=123456; The database=ytodb "
Con. Open
'the code above is the link of SQL server database

The sqlite database
DBName=App. Path & amp; "\ yto db
"Set the Cnn=New_c. Connection
Cnn. OpenDB DBName


Sqlite database to extract the data binding to the datagrid and load data is successful,

Now to save in the datagrid data in SQL server database code below the along while, not out

CodePudding user response:

Do not use the Insert Into statement through the DataGrid, directly from table to table export import library, that is to say, the query and export is parallel,