/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 vote159 views2 answers
What is rownum in oracle
SQL
13 votes149 views3 answers
Uninstall mysql centos 7
SQL
-1 vote131 views2 answers
Sql server date format yyyy-MM-ddThh:mm:ss
SQL
5 votes143 views1 answer
Pl sql asynchronous procedure calls
SQL
6 votes168 views2 answers
Return columns from table sql
SQL
8 votes188 views3 answers
Postgres database sizes
SQL
17 votes149 views4 answers
Postgres list users
SQL
4 votes138 views1 answer
Restart for pg_hba.conf file
SQL
-1 vote144 views1 answer
Sql syntax create timestamp column
SQL
1 vote131 views1 answer
Mysql select another database
SQL