/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

1 vote256 views1 answer
Postgresql where datetrunc month and year equal
SQL
0 vote223 views1 answer
Oracle right characters
SQL
0 vote238 views1 answer
Mysql match in serialized data
SQL
0 vote245 views1 answer
I wanted to select among the rows the highest value in mysql
SQL
0 vote238 views1 answer
FIND LOWEST SALARY EARNER IN SQL
SQL
18 votes216 views6 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
SQL
0 vote240 views1 answer
Mariadb date equals to current_date plus days
SQL
2 votes240 views2 answers
Change mysql password from command line
SQL
0 vote231 views1 answer
Min and max salary and name in sql
SQL
0 vote257 views1 answer
In query in sql
SQL