pagecontents.ascx

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

<%@ OutputCache Duration="60" VaryByParam="*" %>
<%@ Import Namespace="System.Data.SqlClient" %>

<Script Language="C#" Runat="Server">
int CategoryID;

void Page_Load(object sender, EventArgs e) {
	SqlConnection conNorthwind;
	string strSelect;
	SqlCommand cmdSelect;

	conNorthwind = new SqlConnection( @"Server=localhost;Integrated Security=SSPI;Database=Northwind" );
	strSelect = "Select * From Products Where CategoryID=@CategoryID";
	cmdSelect = new SqlCommand( strSelect, conNorthwind );
	cmdSelect.Parameters.Add( "@CategoryID", CategoryID );
	conNorthwind.Open();
	dgrdProducts.DataSource = cmdSelect.ExecuteReader();
	dgrdProducts.DataBind();
	conNorthwind.Close();
}
</Script>

<p>
<h1>Welcome to Our Web Site!</h1>
Here is a list of our current products:
<p>
<asp:DataGrid
  ID="dgrdProducts"
  Runat="Server" />

( Control generated: <%=DateTime.Now%> )
<p>