/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 vote199 views1 answer
Install postgresql on raspberry pi
SQL
0 vote186 views1 answer
Sqlite3 get data from table c
SQL
0 vote191 views1 answer
Insufficient memory to excute the sql query
SQL
0 vote181 views1 answer
Trim sql oracle
SQL
0 vote201 views1 answer
Complete date is 1 year or not sql server
SQL
25 votes246 views5 answers
Mysql replace text
SQL
-1 vote200 views1 answer
Round up and down sql
SQL
0 vote198 views1 answer
Except in sql alchemy
SQL
0 vote200 views1 answer
Caused by: java.lang.RuntimeException: Unable to obtain credentials to communicate with the Cloud SQL API
SQL
0 vote195 views2 answers
How to combine diff colmun value using group by postgres
SQL