Question

sql update 中=附近错误

string sql = "updata book set bookname='" +txt_bookname.Text.Trim() + "'where bookID='" + txt_bookid.Text + "'";

Answer 1

string sql = "update book set bookname='" +txt_bookname.Text.Trim() + "' where bookID='" + txt_bookid.Text + "'";