/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 vote322 views1 answer
How to find top 3 salary in sql
SQL
0 vote313 views1 answer
Is numeric in sql
SQL
1 vote336 views1 answer
Drop function
SQL
25 votes332 views4 answers
Metadata
SQL
0 vote310 views1 answer
Update row in sqlite python
SQL
0 vote337 views1 answer
After kill process Failed to start mysqld.service: Unit mysqld.service not found.
SQL
0 vote353 views1 answer
Postgresql la fonction dblink_connect(unknown, unknown) n'existe pas
SQL
13 votes338 views2 answers
Get tables in database sql
SQL
0 vote334 views1 answer
Mysql count unique in group statement
SQL
4 votes361 views2 answers
Oracle drop job
SQL