MYSQL error codes and ASP.NET

[pechar]

Hi Everyone,

I have a mysql database set up with a couple of constraints here and there.
From the ASP.NET front-end I'd like to handle these constraint errors in a try catch or wherever you could suggest I handle this. But I can't seem to find anything to guide me except for the System.Data.SqlClient SqlException.Number.

Obviously this is for SQLServer I need the same equivalent for MYSQL

I'm using C# and Mysql Odbc Connector. Any idea how I could handle this.

Thanks in Advance
Luke

[pechar]

Just did found the solution for my problem.
When you catch the OdbcException exposes an Errors collection.
Each System.Data.Odbc.OdbcError in this collection exposes a property NativeError (int). This gives you the error code:

E.g. to return the error code for the first error in the Error collection do the following:

try
{
 //execute non query
}
catch (OdbcException e)
{
  if(e.Errors != null && e.Errors.Count > 0)
     return e.Errors[0].NativeError;
}

[Atli]

Glad you found a solution!
Thanks for sharing it with us.