Returning rows affected from an SQL UPDATE statement

[djmlbp]

I have a textbox where the users enter their SQL queries.On example query could be:\[code\]UPDATE customer SET isnew = 1;\[/code\]Running the above query updates 4 rows, how do I get the '4 rows affected' message that which be returned by SQL Server.I've tried using \[code\]InfoMessage\[/code\] but this only returns messages like 'Changed database context to 'databasenamehere' and not the actual rows affected.