/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 vote228 views1 answer
Nvl postgres
SQL
2 votes193 views2 answers
Mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password]
SQL
0 vote202 views1 answer
How to get first 10 records of a table in mysql
SQL
15 votes191 views2 answers
Open postgress in terminal mac
SQL
0 vote189 views1 answer
Jenkins SQLCMD run
SQL
7 votes184 views1 answer
Append column sql
SQL
1 vote194 views1 answer
Postgres first_value in gropby
SQL
2 votes218 views2 answers
Install postgresql
SQL
39 votes289 views4 answers
Select duplicates in sql
SQL
0 vote196 views1 answer
Postgresql select join by date - Join rows where a timestamp value is equal to midnight of the date
SQL