/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

2 votes163 views2 answers
Set value to null sql
SQL
1 vote113 views2 answers
Begin transaction in sql
SQL
-1 vote108 views1 answer
What is in operator
SQL
3 votes107 views1 answer
Oracle sleep
SQL
1 vote107 views1 answer
Sometimes i cant edit sql developer
SQL
8 votes108 views2 answers
Change name of colum in sql table
SQL
0 vote113 views1 answer
Sql select most frequent value in column
SQL
2 votes103 views1 answer
Insert from table tsql
SQL
0 vote135 views1 answer
Mysql date without time
SQL
0 vote110 views1 answer
Check psql validity function
SQL