/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

10 votes292 views2 answers
Django mysql
SQL
-1 vote352 views1 answer
Pl/sql how to delete a trigger
SQL
0 vote364 views2 answers
Impala rename column name
SQL
0 vote309 views1 answer
Select from 3 tables one is empty
SQL
4 votes339 views2 answers
Mysql delete user if exists
SQL
0 vote332 views1 answer
Get rows from 1 table with other table empty mysql
SQL
13 votes270 views2 answers
Oracle all source
SQL
1 vote300 views1 answer
Mysql select utc time in eastern time
SQL
0 vote337 views1 answer
How to add boolean column in postgresql
SQL
20 votes326 views3 answers
SQL query rename table
SQL