how to return stored procedure error?

  • Thread starter Thread starter smen
  • Start date Start date
S

smen

hiye, does anyone know how to return a stored procedure
error to vb.net?

any or all error capture in stored procedure i want em to
be return to vb.net.

thanks for the help..
 
If you are using SQL Server, any RAISERROR with a severity less than 10 can
be caught through InfoMessageEvent. Anything above 10 will result in a
SQLException that needs to be addressed in your ADO.NET code.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Stored Procedure call failed in VB.NET 4
Use ADO.NET Entity Data Model utility for stored procedures or vie 1
Invalid Column Name Sql-Error :Executing a stored procedure 1
Looking for Comments on Code 5
EnterpriseLibrary. Return Recordset from oracle stored procedure 2
How do I determine system vs user stored procedures? 4
ExecuteNonQuery and Stored Procedure 3
LINQ to XML: stored procedure returning result of FOR XML PATH 4

Back
Top