/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 vote115 views1 answer
Sql get number of days between two dates
SQL
6 votes112 views1 answer
Oracle trigger after connect
SQL
0 vote131 views1 answer
How to get button for every record from mysql
SQL
4 votes114 views2 answers
Dbms_scheduler stop job
SQL
2 votes129 views1 answer
Mysql id of inserted row
SQL
4 votes127 views2 answers
Tables in sql
SQL
0 vote114 views1 answer
Heavy table in mysql
SQL
5 votes164 views1 answer
Mysql created at yesterdau
SQL
21 votes115 views1 answer
SQL cheat sheet pdf
SQL
0 vote110 views1 answer
Get max salary from each department sql
SQL