ExecuteNonQuery return value

[Steve]

Dear All,
How can I get the actual error code or message when ExecuteNonQuery is executed?
We can check the status of the ExecuteNonQuery by the return value indicating
number of row affected. If an error occurred, the return value is 0, but
what is the actual error that causing it? Thanks in advance.

Regards,
Steve.

[Michael Gautier]

You should of gotten an exception if there was an error.

if you have

try{
DataThing.ExecuteNonQuery();
}
catch{
}

you won't see it versus

try{
DataThing.ExecuteNonQuery();
}
catch{System.Data.SQLorOracleClient.SQLorOracleException Exception) {
MessageBox.Show(Exception.Message.ToString());
}


SqlException has a number property you can check.

"Steve" <vb.@127.0.0.1> wrote in message
news:3e8129d0$1@tnews.web.devx.com...
>
> Dear All,
> How can I get the actual error code or message when ExecuteNonQuery is
executed?
> We can check the status of the ExecuteNonQuery by the return value
indicating
> number of row affected. If an error occurred, the return value is 0, but
> what is the actual error that causing it? Thanks in advance.
>
> Regards,
> Steve.