global.asax

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

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

<script runat=server>

void Application_Start(Object sender , EventArgs e) 
 {
   SqlConnection conNorthwind;
   string  strSelect;
   SqlDataAdapter dadProducts;
   DataSet dstProducts;

  conNorthwind = new SqlConnection( "Server=localhost;Integrated Security=SSPI;Database=Northwind" );
  strSelect = "Select * From Products";
  dadProducts = new SqlDataAdapter( strSelect, conNorthwind );
  dstProducts = new DataSet();
  dadProducts.Fill( dstProducts, "Products" );
  Context.Cache[ "Products" ] = dstProducts;
}

</Script>