MySql/VB .NET --> Updating/printing

Thenewgeek · 10-28-2005, 09:55 AM

I have a MySql database. this database has two tables (customers and Invoices).
I created a VB .NET application which allows me to access the database. I created a tabcontrol. The first tab is invoices, second tab customers and third tab search.
I got the application to populate the info from the database and I also am able to search the database already.

FIRST PROBLEM:
I have a menu with the options of: add/edit/update/delete/cancel.
Neither option is working.
I need to be able to insert/delete/modified records from both tables.
I've tried a lot of codes but nothing happens.
Can somebody tell me how to code the app so I can add/delete/modified records and the database is updated?

SECOND PROBLEM:
I need to be able to print an invoice to give to the customer. The invoice will need to contain the data in the "tabinvoice" tab control.
How can I do this?

Thanks.

10-28-2005, 09:55 AM	#1 (permalink)
Thenewgeek Registered User Join Date: Sep 2005 Posts: 7 OS: XP	MySql/VB .NET --> Updating/printing I have a MySql database. this database has two tables (customers and Invoices). I created a VB .NET application which allows me to access the database. I created a tabcontrol. The first tab is invoices, second tab customers and third tab search. I got the application to populate the info from the database and I also am able to search the database already. FIRST PROBLEM: I have a menu with the options of: add/edit/update/delete/cancel. Neither option is working. I need to be able to insert/delete/modified records from both tables. I've tried a lot of codes but nothing happens. Can somebody tell me how to code the app so I can add/delete/modified records and the database is updated? SECOND PROBLEM: I need to be able to print an invoice to give to the customer. The invoice will need to contain the data in the "tabinvoice" tab control. How can I do this? Thanks.