/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 vote135 views1 answer
Mysqli::query(): (HY000/1034): Index for table 'db' is corrupt; try to repair it
SQL
3 votes254 views1 answer
Alembic.util.exc.CommandError: Target database is not up to date.
SQL
1 vote143 views2 answers
Procedure syntax
SQL
-2 votes128 views1 answer
How to open database
SQL
0 vote152 views1 answer
Sql remove non numeric characters
SQL
0 vote138 views1 answer
Mysql command prompt date insert format
SQL
2 votes171 views1 answer
Oracle log files
SQL
0 vote131 views1 answer
Min mysql
SQL
0 vote97 views1 answer
Best way to create a temp table with same columns and type as a permanent table
SQL
1 vote94 views1 answer
Oracle boolean to varchar
SQL