No of records effected

  • Thread starter Thread starter John
  • Start date Start date
J

John

Hi

I am executing a query as below;

Dim insStr As String = "INSERT INTO MyTable1 ( field1, field2, ...) ) " & _
"SELECT MyTable.f1, MyTable.f2, " & _
"FROM MyTable "
Dim insCmd As New OleDbCommand(insStr, Conn)
insCmd.ExecuteNonQuery()

Is there a way to get the number of records actually inserted by this query?

Thanks

Regards
 
ExecuteNonQuery does return the number of records affected already.

Dim recsAffected as Integer
recsAffected = insCmd.ExecuteNonQuery()
 
Back
Top