I have a visual basic 2008 datagridview table with Four Columns "IDNum","EmpName","FatherName","DateOfBirth", binding manually to Ms Access 2007 DB table.And on the 2nd form i have three text boxes with the above labels.When i click on any of the the row of the datagridview, the item of the column show in the text boxes on the second form for update.For update I have place an button and write a code for update given below.but when i try to click the button , it gives the error.I try everything but the result is the same.
And the same error is for Delete button.Below is the code for update button .I also attached a screen shot for better understand.Please point out my mistake by any experience person for Visual Basic and MS Access.
Thanks
Loading
Ranjit PowarPosted Jun 19, 2014, 12:54 PM
If datatype of IDNumber is numeric then dont enclosed it in single quot in update query.
Mohammad IshaqPosted Jun 19, 2014, 2:24 PM