update语句中的语法错误。 [英] Syntax error in update statement.
问题描述
我在更新声明中收到错误语法错误,请帮助并指导我。
{con.Open();
mycmd = new OleDbCommand(update empdata set Name ='+ txt2.Text +',Fname =+ txt3.Text +其中Empno =+ txt1.Text +,con);
mycmd.ExecuteNonQuery();
con.Close();}
我是什么尝试过:
我在更新声明中收到错误语法错误,请帮助并指导我。
{con。打开();
mycmd = new OleDbCommand(update empdata set Name ='+ txt2.Text +',Fname =+ txt3.Text +其中Empno =+ txt1.Text +,con);
mycmd.ExecuteNonQuery();
con.Close();}
引用:mycmd = new OleDbCommand(update empdata set Name ='+ txt2.Text +',Fname =+ txt3.Text +where Empno = + txt1.Text +,con);
作为猜测,您错过了txt3.Text
周围的单引号。
I am getting error syntax error in update statement, please help and guide me.
{con.Open();
mycmd = new OleDbCommand("update empdata set Name='"+txt2.Text+"',Fname="+txt3.Text+" where Empno="+txt1.Text+"",con);
mycmd.ExecuteNonQuery();
con.Close();}
What I have tried:
I am getting error syntax error in update statement, please help and guide me.
{con.Open();
mycmd = new OleDbCommand("update empdata set Name='"+txt2.Text+"',Fname="+txt3.Text+" where Empno="+txt1.Text+"",con);
mycmd.ExecuteNonQuery();
con.Close();}
Quote:mycmd = new OleDbCommand("update empdata set Name='"+txt2.Text+"',Fname="+txt3.Text+" where Empno="+txt1.Text+"",con);
As a wild guess, you missed the single quotes aroundtxt3.Text
.
这篇关于update语句中的语法错误。的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!