User Profile

Collapse

Profile Sidebar

Collapse
Create your Exp
Create your Exp
Last Activity: Mar 25 '12, 07:34 AM
Joined: Apr 13 '11
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Create your Exp
    replied to mutli rows copy from datagrid to other datagrid vb6
    in Visual Basic
    thank you for replay


    Code:
    ' To create table in database 2 
Const strConnection As String = "Provider=MSDASQL.1;Persist Security Info=False;User ID=root;Data Source=database 2"
Dim cnn As New ADODB.Connection
Dim cmd As New ADODB.Command
strName = InputBox("Enter table name:", "Table Name")
cnn.ConnectionString = strConnection
cnn.Open
cmd.ActiveConnection
    ...
    See more | Go to post

      Leave a comment:

    • Create your Exp
      started a topic mutli rows copy from datagrid to other datagrid vb6
      in Visual Basic

      mutli rows copy from datagrid to other datagrid vb6

      hi all
      this is my first thread in this forums ,

      now i using adodc connection with ODBC mysql database .
      how i can make the adodc read multi row at the time , not single row at the time, to speed up the process , ?
      example of my work
      Code:
      for i = 0 to adodc1.recoredset.recoredcount 
adodc2.addnew 
adodc2.recoredset.fields(0) = adodc1.recoredset.fields(0)
adodc2.recoredset.fields(1) = adodc1.recoredset.fields(1)
      ...
      See more | Go to post
      Last edited by NeoPa; Jan 8 '12, 08:17 PM. Reason: Added mandatory [CODE] tags for you
      No activity results to display
      Show More
      Working...