Really simple question about looping through a querry
Posted on 2008-10-22
I have the following querry
Dim strSQLLoop As String
strSQLLoop = "SELECT description,unitPrice,extendedAmount,vehicleNumber,qty from imtbl_templineitem"
Dim DBCommandLoop As New SqlDataAdapter(strSQLLoop, "myconnectionstring")
Dim rs As New DataSet
Please give me a example of how I can loop through this record set and insert into another table with each iteration