Article Rating

  • 0 Rating(s)
  • 0
  • 0
  • 0
  • 0
  • 0

How to query an Access Database with OleDB in ASP.net

<%@ import namespace="system.data.oleDb" %>

<Script runat="server">

Sub page_load

 Dim dbconn as oledbConnection
 Dim dbCMD as oleDbCommand
 Dim dtr as oledbdatareader

 ' Server.MapPath("[relative path to your database]")
 dbConn = New oledbConnection ("PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source=" & server.MapPath("/test.mdb"))
 dbConn.open()
 dbCMD = new oleDbCommand ("select * from tblContact",dbconn)
 dtr = dbCMD.executereader()
 
 While dtr.read()
  response.write ("<li>")
  response.write (dtr(0) & "---" & dtr(1))
 End while

 dtr.close()
 dbConn.close()

End Sub

</Script>


If you run into problems when using this code, please post in our community forum. Technical support is unable to assist with specific coding issues.

Article ID: 371, Created On: 11/24/2008, Modified: 4/13/2010