/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 vote153 views1 answer
Search starting with mysql
SQL
0 vote221 views1 answer
Run docker container with database as rds metabase
SQL
0 vote234 views1 answer
Which MySQL data type to use for storing boolean values
SQL
7 votes153 views5 answers
Show details of table postgres
SQL
13 votes142 views5 answers
Select last row mysql
SQL
1 vote148 views1 answer
Table information in sql server
SQL
0 vote162 views1 answer
Postgresql array to rows
SQL
57 votes1.4K views5 answers
How to create a new user in postgresql
SQL
3 votes161 views6 answers
DB::table('users')->get();
SQL
6 votes204 views1 answer
Check Table Exists
SQL