/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

2 votes97 views1 answer
Sql float to int
SQL
0 vote143 views1 answer
Mysql select all where count more than"
SQL
1 vote134 views1 answer
Data type and their numeric form
SQL
0 vote131 views1 answer
User defined variables in sql
SQL
0 vote132 views1 answer
Sql string length postgresql
SQL
0 vote157 views1 answer
Drop table BigQuery table columns
SQL
27 votes259 views3 answers
Mysql delete row
SQL
10 votes135 views1 answer
Create table oracle
SQL
7 votes143 views1 answer
Oracle pagination query offset
SQL
0 vote147 views3 answers
Database restoring error
SQL