/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 vote546 views1 answer
How to connect .sql data set to powerbi
SQL
1 vote272 views1 answer
Host 127.0 0.1 is not allowed to connect to this mysql server
SQL
0 vote315 views1 answer
FIND most frequent word in sql server
SQL
0 vote282 views1 answer
5.Query to raise salary of all employees with 300 in EMP table and display name and salary as new sal from EMP table employee name, job, and salary from EMP table.
SQL
0 vote262 views1 answer
Oracle create table auto generated primary key
SQL
0 vote265 views1 answer
Query to insert image
SQL
2 votes278 views2 answers
Mysql user access to database
SQL
0 vote316 views1 answer
Alternative for LIMIT sql
SQL
-1 vote283 views1 answer
How to dump .csv file into mysql
SQL
3 votes355 views4 answers
Sql interview questions
SQL