Loading

Formatting or Handling Sql Exceptions in c#

chandruswami Ramalingam

16y3.6k.NET

Hi,
In C#, i got sql Exception which consists of 2 lines.
I need only the 2nd line of that Exception only.
Ex:
The transaction ended in the trigger.
Table Validation failed - Name: x; Condition: m!=0
i need "Table Validation failed - Name: x; Condition: m!=0" only.
I have tried e.LineNumber but it not works well.
Can anyone help me?

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

chandruswami Ramalingam16y ago
Wow it works,..
Thanks
Hector Hugo Alpizar Cesena16y ago
did my anwser help you at all?
Hector Hugo Alpizar Cesena16y ago
try this:
string[] linesInArray = strMsjException.Text.Split('\n');
string strResult = linesInArray[1]; //It's a base 0 array
Check the sample code in rar file splitingEnters.rar