/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

49 votes220 views6 answers
Mysql add column to table
SQL
1 vote187 views1 answer
SQL server query column yes or no
SQL
2 votes125 views2 answers
How to create an empty table from an existing table
SQL
1 vote126 views1 answer
Sql upsert
SQL
-1 vote125 views1 answer
Search all tables all columns for a specific value in mssql-server
SQL
0 vote132 views2 answers
Identity syntax in sql
SQL
3 votes138 views3 answers
Update join
SQL
9 votes184 views6 answers
Replace sql
SQL
-1 vote142 views1 answer
Module operator in oracle sql
SQL
9 votes127 views4 answers
How to remove duplicate in sql
SQL