/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

11 votes287 views5 answers
How to install sqlite3 python
SQL
15 votes292 views1 answer
Mysql int range
SQL
0 vote304 views1 answer
T sql dynamic top n query
SQL
1 vote291 views1 answer
Sql dcl
SQL
1 vote273 views1 answer
Oracle sql create or replace view
SQL
5 votes267 views6 answers
Sql add days to date
SQL
1 vote308 views1 answer
Second last highest id in sql
SQL
1 vote285 views1 answer
Mysql month name extract
SQL
4 votes285 views1 answer
Describe table mysql
SQL
0 vote294 views1 answer
Test the postgresql db connection
SQL