sqldatareader.aspx

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

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

<script runat=server>
void Page_Load(Object sender , EventArgs e) 
{
	SqlConnection conPubs;
	SqlCommand cmdSelectAuthors;
	SqlDataReader dtrAuthors;

	conPubs = new SqlConnection( @"Server=localhost;Integrated Security=SSPI;database=pubs" );
	conPubs.Open();
	cmdSelectAuthors = new SqlCommand( "Select au_lname From Authors", conPubs );
	dtrAuthors = cmdSelectAuthors.ExecuteReader();
	while ( dtrAuthors.Read())
	{
		Response.Write( "<li>" );
		Response.Write( dtrAuthors[ "au_lname" ] );
	}
	dtrAuthors.Close();
	conPubs.Close();
}
</script>