/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 vote186 views1 answer
Alter table add column in SQL Server- NAYCode.com
SQL
9 votes176 views3 answers
Where in sql
SQL
0 vote179 views1 answer
Sql insert query list of dictionaries
SQL
0 vote188 views1 answer
ACCEPT nome PROMPT on oracle
SQL
0 vote188 views1 answer
How to export only procedures mysql
SQL
5 votes169 views4 answers
Select random rows sql
SQL
14 votes181 views2 answers
How to auto increment in sql
SQL
0 vote183 views1 answer
Enlever les doubles espaces dans les tables postgresql
SQL
0 vote186 views1 answer
Import sql in postgresql
SQL
0 vote186 views1 answer
Regex mongoose
SQL