/SQL/C# check if mysql query modified rows

C# check if mysql query modified rows

try
        {
            connection.Open();
            cmd = connection.CreateCommand();
            cmd.CommandText = "INSERT INTO BOOK(ISBN, title, author, publisher,imgPath, catalogID) VALUES ('" + isbn + "','" + title + "','" + author + "','" + publisher + "','" + localPath + "','" + catalogid + "')";
            int a= cmd.ExecuteNonQuery();
             if(a>0)
               //updated.
             else
              //Not updated.
        }
catch (Exception)
        {
           //Not updated.
        }

Source: stackoverflow.com

Similar codes

0 vote253 views3 answers
Mysql keyword search
SQL
0 vote247 views1 answer
How to use lower case in mysql
SQL
0 vote278 views1 answer
How to define a non primary composite key in sql
SQL
8 votes284 views1 answer
Oracle search stored procedures for text
SQL
2 votes315 views3 answers
Sql delete duplicate
SQL
0 vote280 views1 answer
Java sql insert return id
SQL
0 vote252 views1 answer
How to get initials in sql
SQL
8 votes362 views2 answers
Select current_timestamp - interval '3 days';
SQL
1 vote262 views1 answer
Events mysql
SQL
0 vote273 views1 answer
Ubuntu stop mysql from starting on boot
SQL