For inserting data to a database, we need to design a user interface that add new product details to database.
Let assume Products = A, B
A = Student RollNumber(sturoll)
B = Syudent Name(stuname)
Database = cheema.mdb
<%
dim vsturoll, vstuname
vsturoll = Request("sturoll")
vstuname = Request("stuname")
dim conn
set conn=server.createobject("Adodb.connection"'conn.open"provider=microsoft.jet.oledb.4.0; datasource="&server.mappath("cheema.mdb")
dim v_query
v_query="insert into stu(sturoll,stuname)values("& vsturoll &"'&stuname & "')"
conn.execute(v_query)
response.write("<b>Record Saver<b>")
conn.close
set conn=nothing
%>
