62,046
社区成员
发帖
与我相关
我的任务
分享
<form id="form1" runat="server">
<div>
<asp:DropDownList ID="DropDownList1" runat="server">
</asp:DropDownList>
<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
<asp:Button ID="Button1"
runat="server" Text="Button" onclick="Button1_Click" />
</div>
</form>
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
using (SqlConnection conn = new SqlConnection("server=localhost;database=northwind;uid=sa;pwd="))
{
SqlCommand cmd = new SqlCommand("select CategoryID, CategoryName from Categories", conn);
conn.Open();
DropDownList1.DataSource = cmd.ExecuteReader(CommandBehavior.CloseConnection);
DropDownList1.DataTextField = "CategoryName";
DropDownList1.DataValueField = "CategoryID";
DropDownList1.DataBind();
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{
Response.Write(DropDownList1.SelectedValue + ", " + TextBox1.Text);
}