/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 vote376 views1 answer
T sql dynamic top n query
SQL
4 votes376 views2 answers
Oracle default date format
SQL
0 vote333 views1 answer
Http://challenge01.root-me.org:58036/wsasd
SQL
1 vote384 views1 answer
Oracle get current schema
SQL
1 vote382 views1 answer
Mysql add fields
SQL
1 vote371 views1 answer
Mysql not supported auth mode
SQL
-1 vote373 views1 answer
Failed to process SQL command - ORA-28014: cannot drop administrative user or role
SQL
0 vote314 views1 answer
How to set field to null in sql
SQL
18 votes340 views2 answers
Sql comments
SQL
0 vote339 views1 answer
Stuff in sql server
SQL