/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 vote232 views1 answer
Mysql loop through databases and execute query
SQL
0 vote160 views4 answers
Mysql count table rows
SQL
0 vote198 views1 answer
Mysql changer nom table
SQL
0 vote210 views1 answer
Tsql cte in a transaction
SQL
0 vote160 views1 answer
Oracle search columns in schema
SQL
0 vote189 views1 answer
Get only one row in mysql
SQL
4 votes162 views3 answers
Sql drop database if exists
SQL
13 votes177 views3 answers
Insert mysql ifile nto database
SQL
2 votes174 views2 answers
Mysql find max value row
SQL
0 vote196 views1 answer
Get only structure database mysql
SQL