/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 vote264 views1 answer
Order by monthly in sql
SQL
1 vote288 views1 answer
Apex ORA-20999
SQL
2 votes285 views1 answer
Oracle apex list connected users
SQL
1 vote272 views3 answers
Rename table snowflake
SQL
0 vote286 views1 answer
Postgresql concat string with separator
SQL
0 vote278 views1 answer
If exist column in table drop sql query mysql
SQL
-1 vote274 views1 answer
Mysql select all columns and specific fields as
SQL
1 vote302 views1 answer
T-SQL / AZURE Reseed
SQL
3 votes277 views2 answers
Oracle grants
SQL
4 votes316 views1 answer
Ms sql truncate table vs delete
SQL