sqlgetauthorcount.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 cmdAuthorCount;
	SqlParameter parmReturnValue;
	int intAuthorCount;

	conPubs = new SqlConnection( @"Server=localhost;Integrated Security=SSPI;database=pubs" );
	cmdAuthorCount = new SqlCommand( "GetAuthorCount", conPubs );
	cmdAuthorCount.CommandType = CommandType.StoredProcedure;
	parmReturnValue = cmdAuthorCount.Parameters.Add( "ReturnValue", SqlDbType.Int );
	parmReturnValue.Direction = ParameterDirection.ReturnValue;
	conPubs.Open();
	cmdAuthorCount.ExecuteNonQuery();
	intAuthorCount = Convert.ToInt32(cmdAuthorCount.Parameters[ "ReturnValue" ].Value);
	conPubs.Close();
	Response.Write( String.Format("There are {0} records in the Authors table", intAuthorCount));
}
</script>