shipmethod.ascx

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

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

<script language="C#" runat="server">

  public void Page_Load(Object Source, EventArgs E)
  {
    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"/>