Why is this not working -ASP.NET, Visual Studio?

C

confused

New member
Hi,

I have a form that has

Persons ID:
Purchase ID:

[Submit]

I am trying to get them to go into an access database, of table name INVOICE and the collumn names are the same as textbox ID's (PersonsID, PurchaseID)

I tried putting in the onclientclick box of the button, the SQL statement that would do this :INSERT INTO table_name (column1, column2, column3,...)
VALUES (value1, value2, value3,...) but it hasnt worked

Getting very frustrated, can anyone advise?

Thanks
I can't show an output, there is no output :S

It doesn't work because when i fill in the form and click submit, nothing happens,

I am not sure what to do
It is not an 'error' it just doesn't do it,

I may well have gone about this the wrong way.

I am using visual studio, each box has been given an ID (such as PurchaseID)

I want to, on submitting the button, have those values go into the database that i have included in the application
 
Best guess would be:

INSERT INTO INVOICE(PersonsID,PurchaseID)
VALUES(personID.text,purchaseID.text);

If that isn't working, what is the error?
 
Back
Top