/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 vote210 views1 answer
Mysql docker image arjun
SQL
0 vote214 views1 answer
Mysql case when null
SQL
33 votes198 views2 answers
Postgres how to add field created at
SQL
0 vote223 views1 answer
No query unable to fetch row sqlite
SQL
2 votes198 views1 answer
Select * from table where name like
SQL
1 vote204 views2 answers
Find a column in all tables mysql
SQL
0 vote219 views1 answer
<connectionStrings> <add name="MainDB" connectionString="Data Source=multidc02.its.com.pk,47328;Initial Catalog=ITSGeneralApplications;User ID=ITSGeneralAdmin;Password=TDsHn6TTyJohXCe"/> </connectionStrings>
SQL
0 vote218 views1 answer
Sql alter table add column if exists
SQL
0 vote199 views1 answer
Run mssql server terminal
SQL
2 votes202 views2 answers
How to rename column name in sql server using query
SQL