shipmethod_cache.ascx

东软内部材料（四）asp等相关的教学案例

<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<%@ OutputCache Duration="10" VaryByParam="none" %>

<script language="CS" runat="server">

  public void Page_Load(Object Source, EventArgs E)
  {
  	DateTime NowTime;
  	DateTime Expires;
  	
    NowTime = DateTime.Now;
    Expires = NowTime.AddSeconds(10);
    CreatedStamp.InnerHtml = NowTime.ToString("r");
    ExpiresStamp.InnerHtml = Expires.ToString("r");


    if (!IsPostBack)
    {
      SqlConnection myConnection;
      SqlCommand myCommand;
      SqlDataReader myReader ;
      string SQL;
      string ConnStr;

      SQL = "select * from Shippers";
      ConnStr = ConfigurationSettings.AppSettings["DsnNorthwind"];

      myConnection = new SqlConnection(ConnStr);
      myConnection.Open();

      myCommand = new SqlCommand(SQL, myConnection);

      myReader = myCommand.ExecuteReader();

      while (myReader.Read())
        ShipMethod.Items.Add(new ListItem(myReader["CompanyName"].ToString(), myReader["ShipperID"].ToString()));

    }
  }
</script>

<asp:DropDownList id="ShipMethod" runat="server"/>
<HR>Fragment Cache created: <Font color=red><B id=CreatedStamp runat=server></B></Font>
	<BR>
	Fragment Cache expires: <Font color=red><B id=ExpiresStamp runat=server></B></Font>