plz help to finde error, with update record, project attached

digitalsindhx 0 Newbie Poster

14 Years Ago

I Applied same Code on a dummy form, it worked, but when i tried it on to a Genuine <Purchase> form on which I want to work, it is not updating record, even every code Syntax is same bit by bit, i cant know where i m doing mistake, whether it is in Database file or in Binding Textboxes with Database or with update statement, Because it returns <Syntax error in INSERT INTO statement.> Error Message, plz help me finding error and mistake,
I m Attaching a zip file,
yes its database file is placed inside Project Folder
<\tryitagain\tryitagain\bin\Debug> file name Is tryitagaindata.mdb

and in coding to return Projects' path where database file is placed i used following Code

Pth = My.Application.Info.DirectoryPath

and in Connectin.connectionstring i used <Pth> Variable to Connect with database as follows

Data Source=" & Pth & "\tryitagaindata.mdb; User Id=admin; Password=;"

here in this project Two forms are added based on same Coding, one of them <Form1> is Working but second one <PurchaseOk> is not working, yes both forms are connected with same Database files but separate tables.
Form Form1 is connected with Tblmaster (Table), and Form Purchaseok is Connected with PurchaseTbl (Table)

Plz Find Project Attachment zip file

Help with this problem or to find out mistakes and error plz
Regards and Best Wishes
Fahad

vb.net

This attachment is potentially unsafe to open. It may be an executable that is capable of making changes to your file system, or it may require specific software to open. Use caution and only open this attachment if you are comfortable working with zip files.

tryitagain.zip (179.23 KB)

1 Contributor
0 Replies
271 Views

Be the first to reply

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.