I don't know any bit of asp here except for the very basics. However, I would like to create a shopping cart based purely on ASP. The shopping cart should have the feature of updating automatically when a product is added. I have the html page ready with me but I have no idea of how to connect the database and carry out the operations using ASP. Please help me. It should be an ecommerce site.
0
votes
1 Answers
1
votes
You can use this code to connect to your database if you are using microsoft-access as database. Just change your database and table name
set conob = Server.CreateObject("ADODB.Connection")
conob.Provider="Microsoft.Jet.OLEDB.4.0"
conob.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & server.MapPath("YourDatabaseName.mdb")
Set rsuni = Server.CreateObject("ADODB.Recordset")
sqlStr="select * from Student_Entry"
rsuni.open sqlStr,conob
If you are using sql server then go to This link. There are answers posted before