/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 vote247 views1 answer
Parent and child link in mysql
SQL
10 votes220 views1 answer
How to import database in mysql by cmd
SQL
4 votes227 views3 answers
NOT NULL SQL
SQL
6 votes209 views1 answer
What is where clause in sql
SQL
0 vote276 views1 answer
Generate random & unique mysql string
SQL
3 votes206 views1 answer
Oracle wait
SQL
2 votes214 views1 answer
Oracle to_char number format percentage
SQL
7 votes223 views6 answers
Group_concat in mysql
SQL
-1 vote202 views1 answer
Round up and down sql
SQL
0 vote207 views1 answer
Aktor yang pernah terlibat di film bergenre Aksi di sql
SQL