/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 vote376 views1 answer
Best sql course
SQL
0 vote388 views1 answer
Mysql row generator
SQL
0 vote344 views1 answer
SQL Error 1040 : Too many connections
SQL
2 votes345 views1 answer
No data found oracle
SQL
1 vote354 views1 answer
How to use a trigger to validate input data
SQL
0 vote359 views1 answer
How to delete python anywhere mysql database
SQL
0 vote359 views1 answer
Vowels in sql
SQL
7 votes375 views2 answers
Where keyword sql
SQL
0 vote365 views1 answer
Import sql inside hide sql
SQL
0 vote357 views1 answer
Remove binlog mysql
SQL