DiscountASP.NET Support Portal
Language
 
Home>Knowledge Base>Programming/Error Message/Sample Code>Sample code>How to query an MS Access 2007 Database with OleDB in ASP.net
Information
Article ID361
Created On11/24/2008
Modified8/6/2009
How to query an MS Access 2007 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.ACE.OLEDB.12.0;DATA Source=" & server.MapPath("/test.accdb"))
 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>