sqlstoredprocedurequery.aspx

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

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

<script runat=server>

void Page_Load(Object sender , EventArgs e) 
{
	SqlConnection conPubs;
	SqlCommand cmdSelect;
	SqlDataReader dtrAuthors;

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