hi everyone...im very new in asp n ive got a project to submit in few dayz..ive got some questions related to asp.
i have a company website in making. now first of all i have to connect everywebpage with the company's database. so that customers can register, track orders and search through the company's database.
We have a customer login form in our web site so customers who wish to brows items on our site must first sign up with us so we have a record. jus like e-bay and stuff. Now the fields in the customer table are zaxtly da same as fields in the registration form so the information can directly be entered in da data base and the customer ID would b used as the customer login name.
now ive made the connection to the database..but im not sure if it's right..its as follows
<%

Dim adoCon 'Holds the Database Connection Object
Dim rsInventory_Control2 'Holds the recordset for the records in the database
Dim strSQL 'Holds the SQL query to query the database
Set adoCon = Server.CreateObject("ADODB.Connection")
adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("Inventory_Control2.mdb")
Set rsInventory_Control2 = Server.CreateObject("ADODB.Recordset")
strSQL = "SELECT tblCustomers.CustomerID, tblCustomers.EMAilAddress FROM tblCustomers;"
rsInventory_Control2.Open strSQL, adoCon
Do While not rsInventory_Control2.EOF

     Response.Write ("<br>")
     Response.Write (rsInventory_Control2("Customer ID"))
     Response.Write ("<br>")
     Response.Write (rsInventory_Control2("Email Address"))
     Response.Write ("<br>")


     rsInventory_Control2.MoveNext

Loop

rsInventory_Control2.Close
Set rsInventory_Control2 = Nothing
Set adoCon = Nothing
%>

now first things first...how do i make the information written in registration form be part of the database(i.e add to database) and save it for future reference...plz give the codes if possible...i think we have to use some sort of SQL query....initialize a variable and assign a value to it
PLZ HELP ASAP
thx

Hi angelfire,

To input data to database, in this case is access, you can use SQL Query or recordset.

example:
after users submit the form,

- Using SQL Query.
Set adoCon = Server.CreateObject("ADODB.Connection")
adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("Inventory_Control2.mdb")
SQL = "insert into [TABLENAME] ([FIELD1], [FIELD2], ....) values ([VALUE1], [VALUE2], ....)"
adoCon.execute SQL


-Using Recordset
Set adoCon = Server.CreateObject("ADODB.Connection")
adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("Inventory_Control2.mdb")
Set rsInventory_Control2 = Server.CreateObject("ADODB.Recordset")
strSQL = "SELECT tblCustomers.CustomerID, tblCustomers.EMAilAddress FROM tblCustomers;"
rsInventory_Control2.Open strSQL, adoCon, 2, 3
rsInventory_Control2.AddNew
rsInventory_Control2("FIELD1") = VALUE1
rsInventory_Control2("FIELD2") = VALUE2
.
.
.
.
.
rsInventory_Control2.Update
rsInventory_Control2.Close
Set rsInventory_Control2 = Nothing
Set adoCon = Nothing


Regards,
Sherief C. Mursyidi