/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

5 votes144 views2 answers
Copy data from one database to another
SQL
12 votes203 views2 answers
Update column data type postgres
SQL
0 vote156 views1 answer
Query only first letter string
SQL
2 votes136 views2 answers
Oracle create table if not exists
SQL
0 vote168 views1 answer
Unique element in sql
SQL
0 vote145 views1 answer
How to select only id where is not in column mysql
SQL
0 vote177 views1 answer
Mysql trigger to delete old data
SQL
12 votes160 views4 answers
Psql command not found
SQL
0 vote245 views1 answer
Mysql select field if condition
SQL
1 vote150 views1 answer
Mysql average of multiple columns
SQL