If you have seen the connection of database for visual basic this page is very useful for connecting database in ASP.
Dim Connectdata
Dim Connectstring
Dim SQLstring
Dim Recorddata
Connectstring = "Provider=SQLOLEDB; Datasource=datasource; Database=Testdata; UID=user id of database; PWD= Password for database;"
Set Connectdata = Server.Createobject("ADODB.Connection")
Connectdata.connectionstring = Connectstring
Connectdata.mode = Readwrite
Connectdata.open
Set Recorddata = Server.Createobject("ADODB.Recordset")
SQLstring = "select * from testdata"
Recorddata.open SQLString, Connectdata, [Locktypes for the database]
Following methods to move inside the recordset
Recorddata.movefirst
Recorddata.movelast
Recorddata.moveprevious
Recorddata.movenext
