D
Darren Gulliver
Hi,
When you run a select query how do you return the number of records in the record set?
IE:
Try
Dim objCommand As New SqlClient.SqlCommand ("Select Field1, Field2 on from Table", objConn)
Dim objReader As SqlClient.SqlDataReader
DBConnection.OpenConnection()
objReader = objCommand.ExecuteReader
iRecordsRtn = objReader.?
'''###Long time since I used ADO but I'm sure you could use rs.RecordCount
Catch err As Exception
display error
End Try
TIA
Darren
When you run a select query how do you return the number of records in the record set?
IE:
Try
Dim objCommand As New SqlClient.SqlCommand ("Select Field1, Field2 on from Table", objConn)
Dim objReader As SqlClient.SqlDataReader
DBConnection.OpenConnection()
objReader = objCommand.ExecuteReader
iRecordsRtn = objReader.?
'''###Long time since I used ADO but I'm sure you could use rs.RecordCount
Catch err As Exception
display error
End Try
TIA
Darren