oledbdatareader.aspx

asp.net技术内幕的书配源码

<%@ Page Language="C#"%>
<%@ Import Namespace="System.Data.OleDb" %>

<script runat=server>
void Page_Load(Object sender , EventArgs e) 
{
OleDbConnection conAuthors;
OleDbCommand cmdSelectAuthors;
OleDbDataReader dtrAuthors;

conAuthors = new OleDbConnection( "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source=c:\\Authors.mdb" );
conAuthors.Open();
cmdSelectAuthors = new OleDbCommand( "Select au_lname From Authors", conAuthors );
dtrAuthors = cmdSelectAuthors.ExecuteReader();
while ( dtrAuthors.Read())
{
  Response.Write( "<li>" );
  Response.Write( dtrAuthors[ "au_lname" ] );
}
dtrAuthors.Close();
conAuthors.Close();
}
</script>