L
Luis Esteban Valencia
How would I quickly read several records (rows) from a SQL table, change the
key in each (recordid) and insert them back into the same table thus
creating duplicates.
I'm reading the rows like this:
Dim strSQL As String = _
"SELECT * FROM XMMProjDet " & _
"WHERE Project = '" & Trim(txtProject.Text) & "' and
ProposalNbr = " & Trim(txtCopyFrom.Text)
Dim scnnSol As New SqlConnection(SQL_CONNECTION_STRING)
Dim scmd As New SqlCommand(strSQL, scnnSol)
scnnSol.Open()
Dim myReader As SqlDataReader = scmd.ExecuteReader()
Thanks much.
key in each (recordid) and insert them back into the same table thus
creating duplicates.
I'm reading the rows like this:
Dim strSQL As String = _
"SELECT * FROM XMMProjDet " & _
"WHERE Project = '" & Trim(txtProject.Text) & "' and
ProposalNbr = " & Trim(txtCopyFrom.Text)
Dim scnnSol As New SqlConnection(SQL_CONNECTION_STRING)
Dim scmd As New SqlCommand(strSQL, scnnSol)
scnnSol.Open()
Dim myReader As SqlDataReader = scmd.ExecuteReader()
Thanks much.