/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

2 votes213 views3 answers
Write sql query to find the second highest salary of employee
SQL
0 vote208 views1 answer
How to connect to mysql in ef 6
SQL
1 vote230 views1 answer
Change default maximum runtime mariadb from phpmyadmin
SQL
0 vote209 views1 answer
Min mysql
SQL
4 votes198 views2 answers
What is table in sql
SQL
1 vote211 views2 answers
Select only columns that are not empty oracle sql
SQL
2 votes171 views1 answer
Sql float to int
SQL
0 vote228 views1 answer
[object Object]: BY KimbleOne__DeliveryGroup__c, CreatedDate ^ ERROR at Row:1:Column:142 field 'CreatedDate' can not be grouped in a query call
SQL
7 votes222 views1 answer
Xampp reset mysql
SQL
1 vote213 views1 answer
Ef core 5.0 usesqlserver not found
SQL