/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

4 votes106 views1 answer
What are the data types in sql
SQL
7 votes108 views1 answer
Sql server convert string to date
SQL
10 votes143 views6 answers
Mysql set root password
SQL
0 vote128 views1 answer
Increase speed of like queries postgres
SQL
0 vote102 views1 answer
Suse start MySQL
SQL
0 vote112 views1 answer
Alter table name including schema
SQL
1 vote116 views1 answer
Sql server today minus n
SQL
0 vote122 views1 answer
Mysql Install Ubuntu with native password
SQL
2 votes123 views1 answer
Sql server case sensitive search
SQL
0 vote120 views1 answer
MySQL FIND_IN_SET()
SQL