Member Avatar for amitesh11

I got error like syntaxt error in update statment
strcmd="update emp set Name='"+txtname.Text+"',where id="+tsxid.Text

cmd=new OledbCommand(strcmd,con);
cmd.ExecuteNonquery();

  • 3 Contributors
  • 2 Replies
  • 76 Views
  • 3 Hours Discussion Span
  • Latest Post Latest Post by Jan-Willem
Member Avatar for Ancient Dragon

Missing quotes around the last item tsxid.Text

Member Avatar for Jan-Willem

also, there's a comma before WHERE

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.