/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 vote156 views1 answer
Oracle create job if not exists
SQL
-1 vote164 views2 answers
Postgresql get last 10 records
SQL
4 votes170 views1 answer
For loop postgresql
SQL
0 vote159 views1 answer
Alter table engine mysql
SQL
0 vote175 views1 answer
How to map sql column to custom names
SQL
0 vote181 views1 answer
Permission denied postgres \copy csv command line
SQL
10 votes152 views4 answers
How to alter table name in mysql
SQL
0 vote174 views1 answer
The fetch keyword oracle
SQL
4 votes150 views2 answers
Mysql select where starts with
SQL
0 vote160 views1 answer
How to query without duplicate rows in sql
SQL