/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 vote187 views1 answer
Mysql show category once count how many products
SQL
4 votes197 views2 answers
How to count items with same name in sql
SQL
1 vote183 views1 answer
Deleting database in sql
SQL
1 vote198 views1 answer
Oracle create as select
SQL
7 votes240 views1 answer
Xampp reset mysql
SQL
25 votes236 views6 answers
Import database mysql command line
SQL
5 votes196 views1 answer
Oracle nls session
SQL
5 votes220 views3 answers
Show indexes mysql
SQL
0 vote211 views1 answer
How to check which table has data in mysql
SQL
0 vote269 views1 answer
Sql select first and last record of each group
SQL