Codeasearch.com - Search your code with us Login | Register | Contact us
  Forums > Asp > Adodb.Recordset
forums_reader
Posted on Jul 20, 2007
Join Date: July 2007
Location: India ( Chennai )
Posts: 24
 
Adodb.Recordset  

<%
Map your database
path = server.MapPath("yourdb.mdb")

'Creating Adodb Connection
set con = server.CreateObject("Adodb.Connection")

'Provider
con.Provider ="Microsoft.Jet.OLEDB.4.0"

Open Connection
con.Open path

'Creating Adodb Recordset
set rs = server.create("Adodb.Recordset")

'Sql Statment
rs.open "select * from yourtable",con

do until rs.eof
response.write rs(1)
s.movenext
loop
%>

 Hot Discussion
Go Tech launches Android tablet for Rs 3,999...
Sony targets retailers with quick sales pitches and rew...
Share and discover new activities with Google Schemer...
Samsung gets 9 mn preorders for Galaxy S3: Report...
Google revamps search engine to think like a person...
 
 Discussion Topics
IT News
Php
Javascript
Technology Updates
Asp.Net
MySql
Ajax
Html
Fedora
Software Testing
Asp
Java
General
Flash
Ruby on Rails