3
Answers

Formatting or Handling Sql Exceptions in c#


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?
Answers (3)
2
Hector Hugo Alpizar Cesena

Hector Hugo Alpizar Cesena

NA 536 188.2k 14y

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
 

Wow it works,..
Thanks
0
Hector Hugo Alpizar Cesena

Hector Hugo Alpizar Cesena

NA 536 188.2k 14y
did my anwser help you at all?