Breaking News: Grepper is joining You.com. Read the official announcement!

C# check if mysql query modified rows

Powerful Penguin answered on March 24, 2020 Popularity 1/10 Helpfulness 1/10

answer C# check if mysql query modified rows

C# check if mysql query modified rows

Comment

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.
        }

Popularity 1/10 Helpfulness 1/10 Language sql

Source: stackoverflow.com

Tags: c# mysql rows sql

Link to this answer
Share Copy Link