disoplaying number of rows.

ashokparchuri · April 18th, 2005, 11:12 PM

hi.
   the stored procedures in my databse are designed in a way that if anything goes wrong it retuns an error message.

   in asp i think we can get the message into an variable using "err".

    i want to get thease error message into variable and display the error.please tell me how to do that.

  thanks in advance-Ashok Parchuri.

ejan · April 20th, 2005, 07:43 AM

Dear ashokparchuri,

Handling with errors in C# .NET is different than VB or ASP. C# uses what are called

Exceptions to handle errors. Specifically, the mechanism used is the try, catch and

finally blocks.

If you expect a portion of code to run into some sort of error, you enclose that code in a try block. Immidiately following the try block, you write a catch block that catches any thrown exceptions. Finally, following the catch block, you write finally block. It contains code that you want to be executed whether or not an exception is thrown (error is raised, in old VB terminology). Here is the general syntax:

Code:

try {
  //code that can throw exception goes here...
}
catch(Exception ex) {
  MessageBox.Show(ex.Message, "Error");
  //code to handle the exception goes here...
}
finally {
  //code that you want to be executed whether
  //or not an exception is thrown goes here...
}

If you prefer you can omit the finally block or the catch block. But at least one of them has to

be there immidiately following the try block.

I hope this would help. But for a complete coverage of error handling in C# you should consult

a good book, such as C# Step By Step (Microsoft Press) or C# .NET Unleashed (SAMS Publishers).

ejan

r_ganesh76 · April 21st, 2005, 04:28 AM

Ashok,

I would like to make some clarifications on your question.

Quote:

quote:if anything goes wrong it retuns an error message.

Quote:

What exactly do u mean by "it returns" do you throw the error using "RAISERROR" or do you return it as a return parameter.

if you are throwing an error, the solution suggested by ejan is going to work. Otherwise you need to get the value of the return parameter from your code and display it accordingly.

Regards
Ganesh