how can i return the number of records processed from an sql procedure wether it is a select or update/insert query and how can i receive it in the calling method in vb .net.
Printable View
how can i return the number of records processed from an sql procedure wether it is a select or update/insert query and how can i receive it in the calling method in vb .net.
If you call Fill or Update on a DataAdapter or ExecuteNonQuery on a Command, they will return the number of records affected.
please help me with the syntax.
Follow the Database FAQ link in my signature and you'll find various ADO.NET resources that can show you what to do.
thanks