/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 vote342 views1 answer
Function plsql
SQL
0 vote322 views1 answer
Oracle right characters
SQL
3 votes322 views1 answer
Insert into table from another table mysql
SQL
12 votes356 views2 answers
Select into insert sql server
SQL
4 votes370 views2 answers
Sqlalchemy_database_uri for mysql
SQL
2 votes390 views1 answer
Mysql shell insert into
SQL
2 votes348 views1 answer
How to delete all duplicate items in mysql
SQL
0 vote328 views1 answer
Postgres full text search example
SQL
0 vote346 views1 answer
Rabbitmq ui not working
SQL
0 vote343 views1 answer
Django mssql backend
SQL