shipmethod_event.ascx

来自「东软内部材料（四）asp等相关的教学案例 」· ASCX 代码 · 共 47 行

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

<script language="C#" runat="server">
  string ConnStr;

  public string ConnectionString
  { 	
  	get {return ConnStr; }
  	set {ConnStr = value;}
  }

  public void Page_Load(Object Source, EventArgs E)
  {
    if (!IsPostBack)
    {
      SqlConnection myConnection;
      SqlCommand myCommand;
      SqlDataReader myReader;
      string SQL;

      SQL= "select * from Shippers";
      if (ConnStr == "")
      	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()));
    }
  }
  
  
  public void ShipMethod_Change(Object Source, EventArgs E)
  {
 	SelectedMethod.Text = "You have selected " + ShipMethod.SelectedItem.Text + " as your shipping method.";
  }  
  
</script>

<asp:DropDownList AutoPostBack="true" OnSelectedIndexChanged = "ShipMethod_Change" id="ShipMethod" runat="server"/>
<BR><asp:Label id="SelectedMethod" runat="server"/>