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();}