/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 vote133 views1 answer
Base64 encode sql server
SQL
0 vote138 views1 answer
Sql get highest date from 3 tabels
SQL
3 votes98 views2 answers
Coalesce mysql
SQL
1 vote115 views1 answer
Real world example of nosql
SQL
0 vote151 views2 answers
How to retrive image from sql to picturebox usinf image location
SQL
0 vote141 views1 answer
Sql server python connection
SQL
1 vote98 views2 answers
Delete auto increment mysql
SQL
0 vote124 views1 answer
Mysql select last 15 minutes
SQL
8 votes135 views1 answer
How to check mysql version in xampp
SQL
1 vote131 views1 answer
Drop function
SQL