/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 vote358 views1 answer
Get substract count sql
SQL
0 vote274 views1 answer
Split a string with expression and get the last value of split sql
SQL
0 vote299 views1 answer
Oracle merge insert if not exists
SQL
13 votes320 views2 answers
Sql join 3 tables
SQL
1 vote316 views1 answer
Mysql check string don't have number
SQL
1 vote318 views2 answers
Postgres cast as decimal
SQL
0 vote303 views1 answer
CALCULATING MONTHS BETWEEN TWO DATES IN POSTGRESQL
SQL
4 votes308 views1 answer
Refresh postgres config
SQL
0 vote281 views1 answer
Zsh: command not found: mysql mamp
SQL
2 votes331 views1 answer
Sqlplus clear screen
SQL