/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 vote199 views1 answer
How to make case insensitive in sql
SQL
-2 votes212 views2 answers
Add auto_increment column to existing table mysql
SQL
1 vote240 views2 answers
Install sql server management studio ubuntu
SQL
0 vote236 views1 answer
Eliminate zero from integer mysql
SQL
0 vote224 views1 answer
Npm ERR! code ELIFECYCLE npm ERR! errno 1 npm ERR! [email protected] install: `node-pre-gyp install --fallback-to-build` npm ERR! Exit status 1 npm ERR! npm ERR! Failed at the [email protected] install script.
SQL
0 vote204 views1 answer
Min:sec datediff mssql
SQL
7 votes223 views6 answers
Group_concat in mysql
SQL
1 vote218 views1 answer
Add multiple row table pl sql
SQL
1 vote235 views1 answer
Apex run 404
SQL
0 vote204 views2 answers
Mysql multiply
SQL