samplepage.aspx

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

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

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

  void Page_Load(Object Sender, EventArgs E)
  {
    if (!Page.IsPostBack)
    {
        state.Items.Add("CA");
        state.Items.Add("IN");
        state.Items.Add("KS");
        state.Items.Add("MD");
        state.Items.Add("MI");
        state.Items.Add("OR");
        state.Items.Add("TN");
        state.Items.Add("UT");
    } 
  }

  void ShowAuthors(Object Sender, EventArgs E)
  {
    SqlConnection con = new SqlConnection(ConfigurationSettings.AppSettings["DsnPubs"]);
    SqlCommand cmd;
    string qry;
    
    con.Open();
    
    qry = "select * from authors where state='" + state.SelectedItem.Text + "'";
    cmd = new SqlCommand(qry, con);
    
    DataGrid1.DataSource = cmd.ExecuteReader();
    DataGrid1.DataBind();
    
    con.Close();
  }
  
</script>

<form runat="server">

  State: <asp:DropDownList id="state" runat="server" />
  
  <asp:Button Text="Show Authors" OnClick="ShowAuthors" runat="server"/>

  <p/>  
  <asp:DataGrid id="DataGrid1" runat="server"/>

</form>