Im trying to write some code that will take the results of a query and use those results to insert them into a new table in SQL05, not to sure how to accomplish this. Do I need a SQLAdapter? Do I need to save the results of the query into a dataset and use the dataset to populate the table?
Any help or ideas will be of great help. Im new to vb.net so some code example will be of great help.
This is the part of the code that I have so far:
Dim SQL3 As String = "SELECT FIL1, FIL2,FIL3,FIL4 FROM activitydetail where activity_id > " & CStr(minActivityID) & " and activity_id <= " & CStr(maxActivityID) & " and customer_id = 1"
' Create command object
Dim cmd3 As New OdbcCommand(SQL3)
cmd3.Connection = TVconn
' Call command's ExecuteReader
Dim reader3 As OdbcDataReader = cmd3.ExecuteReader()
&&&Next I will like to take those results which are about 7,000 rows and insert them into a new table in SQL05.