/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

1 vote127 views1 answer
Get table which have specific columns in mysql
SQL
-1 vote100 views1 answer
Mysql if example
SQL
0 vote127 views1 answer
How to install mysql without admin rights
SQL
0 vote128 views1 answer
SQLSTATE[42000]: Syntax error or access violation: 1140 Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
SQL
0 vote142 views1 answer
Postgres list all triggers
SQL
0 vote121 views1 answer
Différence entre deux dates sql oracle
SQL
1 vote113 views1 answer
Error code 1175 mysql fix
SQL
-1 vote156 views2 answers
Sql truncate number
SQL
0 vote123 views1 answer
Show create table in postgresql
SQL
10 votes117 views2 answers
Linux command line import mysql database
SQL