Is it possible to Format Sql Exceptions?

[chandruswami]

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?

[Gospp]

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?

Hi

One way of doing it could be:

catch (Exception ex)
{
	string[] lines = Regex.Split(ex.Message, "\r\n");
	MessageBox.Show(lines[1]);
}

Good luck!

[chandruswami]

Gossp!
It works,.../

Thanks
Chandru