hey everybody,
i am new to vb.net environment pls help me to sort out my problem. let me explain it.
in my project i need to clone/copy the content of the two fields from one table to another table in same database.i have tried my level best but got the error in coding. can anuyone solve it pls. its vry urgent.

        Dim tblProducts As DataTable
        Dim tblProductsCopy As DataTable
        Dim tblProductsCount, tblProductsCopyCount, i As Integer
        conn = New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Module2.accdb")
        Dim da As OleDbDataAdapter 'Create the DataAdapter.
        da = New OleDbDataAdapter("Select Itemname,ItemCode from sub", conn)
        Dim ds As DataSet = New DataSet("Products")

        da.Fill(ds, "products")

        tblProductsCount = tblProducts.Rows.Count

        tblProductsCopy = tblProducts.Clone()


        tblProductsCopyCount = tblProductsCopy.Rows.Count

    Catch ex As Exception
    End Try

Something like this would do the trick:

"INSERT INTO destinationTable(Itemname,Itemcode)" & _
  "SELECT sourceTable.ItemName, sourceTable.ItemCode " & _
   "FROM sourcetable WHERE sourcetable.Column=Value"

Edited 4 Years Ago by Begginnerdev

This question has already been answered. Start a new discussion instead.