helo i am developing an vb.net access application.i am frustrated with this access that i am getting error while updating records.
Data Type Mismatch In criteria expression
here is the code , if i run the sql statement its works fine .but thru vb.net its giving error.i am not understadning the problem.pls help
sql = "update Tbl_Pat_Registration set Pat_name='" & Trim(txt_name.Text) & "',pat_id='" & Trim(Txt_id.Text) & "' where id='" & id & "'"
cmd.CommandText = Sql
cmd.Connection = CON
MsgBox("Record Updated Successfully")