/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 vote289 views1 answer
Execute a stored procedure in another stored procedure in SQL server
SQL
1 vote284 views1 answer
Create temporal table in sql
SQL
-2 votes287 views3 answers
Oracle tablespace usage
SQL
2 votes306 views2 answers
Postgres change owner of schema
SQL
0 vote293 views2 answers
Reduce size of SQL server log file truncate - Source :NAYCode.com
SQL
28 votes337 views6 answers
Sql update
SQL
2 votes317 views2 answers
Spring import sql
SQL
23 votes292 views4 answers
How to uninstall postgresql in ubuntu
SQL
7 votes323 views4 answers
Index in mysql
SQL
0 vote287 views1 answer
Sql server convert date to weekday
SQL