/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 vote144 views2 answers
How to create a table from another table in sql derby
SQL
7 votes146 views1 answer
Buy forge mods server hosting
SQL
20 votes179 views4 answers
How to find average in sql
SQL
1 vote134 views1 answer
Mysqli connect
SQL
19 votes137 views2 answers
Mysql add column after another
SQL
16 votes141 views2 answers
Sql exists
SQL
0 vote151 views1 answer
Compare two tables to find unmatched records
SQL
0 vote143 views1 answer
Mysql url
SQL
1 vote149 views1 answer
Oracle create_program
SQL
7 votes135 views2 answers
Show size database mysql
SQL