/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

19 votes320 views5 answers
Mysql between date range
SQL
3 votes331 views2 answers
Install mysql powershell
SQL
1 vote317 views1 answer
Order by oracle
SQL
0 vote330 views1 answer
Sql show table name in result
SQL
0 vote330 views1 answer
Mysql set variable to today's date
SQL
0 vote311 views1 answer
Mssql check if date is greater than today
SQL
0 vote338 views1 answer
Sql commands in android
SQL
0 vote335 views1 answer
Can we rollback data that are deleted using DELETE clause?
SQL
0 vote346 views1 answer
Sql: extract day text from datetime value
SQL
0 vote329 views1 answer
Kill mysqld_safe process mariadb
SQL