/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 vote165 views1 answer
Mysql find foreign key references
SQL
1 vote145 views1 answer
Database run
SQL
4 votes264 views4 answers
Remove duplicate old value in mysql
SQL
22 votes165 views2 answers
Mysql show all tables
SQL
0 vote202 views2 answers
How to login to mysql as normal user in ubuntu
SQL
0 vote190 views1 answer
Sqlalchemy get schema from database
SQL
1 vote200 views1 answer
Update from select join
SQL
0 vote204 views1 answer
Postgresql show owner of database
SQL
7 votes189 views3 answers
Foreign key oracle
SQL
0 vote194 views1 answer
Mysql group by range
SQL