I want to know how many records have been affected by a sql statement
I use dr.RecordsAffected.ToString
but it does not respond!
here is the code:
Dim strSQL3 as string
strSQL3 = "SELECT * from test where e=1"
    objConnection = New SQLConnection(strConnection)
    cmd = New SQLCommand(strSQL3, objConnection)
    objConnection.Open()
    dr = cmd.ExecuteReader()

 If dr.HasRows = False Then
          strNewMsgCount=0
 End If

Do while (dr.Read())
strTotal=dr.RecordsAffected.ToString
Loop

dr.Close()

This can be done with a stored procedure and defining an output parameter like so

CREATE PROCEDURE [someprocedure]
(
  @Rows int output
)

SET @Rows = @@ROWCOUNT

then just deal with it in code.

this post may help you as well:
http://www.dotnet247.com/247reference/msgs/5/25190.aspx

"The one language all programmers understand is profanity."

Thanks