/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 vote144 views1 answer
Sqlite send a query to a Sqlite DB with Ruby
SQL
0 vote126 views2 answers
How to retrive image from sql to picturebox usinf image location
SQL
1 vote132 views1 answer
How not to sort by average rating
SQL
0 vote143 views3 answers
Mysql CAST(amount as float)
SQL
2 votes113 views3 answers
Application.properties spring boot mysql
SQL
1 vote51 views1 answer
Metada in sql
SQL
5 votes97 views3 answers
How to remove unique key constraint in mysql
SQL
9 votes100 views4 answers
SQL Date Format
SQL
0 vote99 views1 answer
How to make full text search dynamic in mysql
SQL
12 votes98 views4 answers
Mysql version
SQL