How to get the number of rows affected from SQL Server on VB.NET?

Question

Basically I retrieve all the data in my program at runtime, I was wondering how I will get the number of rows affected after the update so that I can ask the user about it through VB.NET

What I'm actually doing, after updating, if there are no other updated lines, then the user can no longer click the button

Answer 1

Using ExecuteNonQuery , it will not return rows; any output parameters or return values ​​associated with parameters are filled with data.

For UPDATE, INSERT, and DELETE statements, the return value is the number of rows affected by the command.

EDIT:

You can ask the user how

Dim RowsAffected as Integer = Command.ExecuteNonQuery() MsgBox("The no.of rows effected by update query are " & RowsAffected.ToString) 

Answer 2

If you use the SQLCommand object directly, calling ExecuteNonQuery returns the number of rows affected:

 Dim I as Integer= MyCommandObject.ExecuteNonQuery() 

Hope this makes sense.

Answer 3

You can use SqlCommand for this:

 Dim cmd As SqlCommand Dim rows_Affected as Integer rows_Affected = cmd.ExecuteNonQuery() 

Answer 4

You can update your statements to return the rowcount value.

This should be useful http://technet.microsoft.com/en-us/library/ms187316.aspx