Low cost ecommerce web development India flash website design
Inserting Data into a Table
Although SQL provides us the INSERT INTO statement for inserting records
into a database, I would suggest using the ADODB.Recordset object for doing
this to make things simpler.
So here’s how you insert a new record:
<HTML>
<HEAD>
<TITLE>Student Records</TITLE>
</HEAD>
<BODY>
<%
Dim DB
Set DB = Server.CreateObject (“ADODB.Connection”)
DB.Mode = adModeReadWrite
DB.Open ("PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" +
“C:\Databases\Students.mdb”)
Dim RS
Set RS = Server.CreateObject (“ADODB.Recordset”)
RS.Open “Students”, DB, adOpenStatic, adLockPessimistic
RS.AddNew
RS (“FirstName”) = “Manas”
RS (“LastName”) = “Tungare”
RS (“Email”) = “manas@manastungare.com”
RS (“DateOfBirth”) = CDate(“4 Feb, 1980”)
RS.Update
%>
</BODY>
</HTML>
Freelance web designer ASP PHP ecommerce web development India