Stored Procedures returning errors...

[TPetersonFlorida]

I have an ASP.Net application that calls various stored procedures. I have not yet figured out how to access an error that is raised in the stored procedure from the calling application. Any help is appreciated!!!

Thanks!

 

[dragonwell]

If the SPROC causes an error, an SqlException is thrown. Use a Try/Catch block to trap that error and display the results.

try
{
    mySqlConnection.Open();
    mySqlCommand.ExecuteNonQuery(); // or whatever...
}
catch(Exception x)
{
    Trace.Warn(x.ToString());
}
finally
{

    mySqlConnection.Close();
}

If you have Trace enabled in your application, any errors will show up in red in the Trace output if an exception occurs there. Note that the finally block will always execute even if an exception occurs, so it's a good place to close your connection.

Greetings,
Dragonwell