How to create a datareader on an Access database using ASP.NET
Print
Create a DataReader
The OleDbDataReader class is used to read a stream of records from a data
source. A DataReader is created by calling the ExecuteReader method of the
OleDbCommand object:
<%@ Import Namespace="System.Data.OleDb" %>
<script runat="server">
sub Page_Load
dim dbconn,sql,dbcomm,dbread
dbconn=New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;
data source=" & server.mappath("northwind.mdb"))
dbconn.Open()
sql="SELECT * FROM customers"
dbcomm=New OleDbCommand(sql,dbconn)
dbread=dbcomm.ExecuteReader()
end sub
</script>
|
|
Was this answer helpful?
