How to get error code returned by query using MySQL in Asp.Net

Question

I am working with MySQL in my .net web app with the help of MySQL connector 5.0.9.0. I am getting data from a web service and inserting it in local database. I only want to insert unique rows in my local database. I came to know that when an duplication occurs, MySQL returned an error code: 1062. All i want to know that how i could i get this code in a variable and check it against my condition like:

if(errorCode == "1062")
{
    Response.Write("Record already exists");
}

else
{
    // add the record to database
}

Thanx in advance

Devart · Accepted Answer · 2013-03-13 07:37:02Z

2

Have a look at MySqlException class members. There is a Number property - Gets a number that identifies the type of error.

MySqlException Class.

answered Mar 13, 2013 at 7:37

Devart

120k23 gold badges172 silver badges189 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to get error code returned by query using MySQL in Asp.Net

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related