none
Update error in ADO RRS feed

  • Question

  • Error occur from following update statement.

    UpdateQuery = "UPDATE cdmr_option SET anstext = '" + AccountSid + "'" +
                  " WHERE option_name = 'AccountSid'";
    cmd = new OleDbCommand(UpdateQuery, conn_CDMR);
    cmd.ExecuteNonQuery();
    cmd.Dispose();
    

    Exception message is "Query '' is corrupt."

    If I run this update query from MS Access Query view, it works well.

    Can anybody give me advice?

    Is there any way to update in ADO.NET?

    Saturday, November 23, 2019 4:04 AM

Answers

All replies