drop in session_drop constraint

//aspx <asp:Repeater ID=”Repeater1″ runat=”server” OnItemDataBound=”Repeater1_ItemDataBound”> <ItemTemplate> <asp:Label ID=”Label1″ runat=”server” Text='<%# DataBinder.Eval(Container.DataItem, “au_id” ) %>’></asp:Label> <asp:DropDownList ID=”DropDownList1″ runat=”server”> </asp:DropDownList> <br /> </ItemTemplate> </asp:Repeater>

//aspx.cs protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { SqlConnection cn = new SqlConnection(@”Server=.\SQLEXPress;uid=sa;pwd=password;Database=Pubs”); string strSQL = “select * from authors”; SqlCommand cmd = new SqlCommand(strSQL, cn); cn.Open(); SqlDataReader dr = cmd.ExecuteReader(); Repeater1.DataSource = dr; Repeater1.DataBind(); dr.Close(); cn.Close(); } } protected void Repeater1_ItemDataBound(object sender, RepeaterItemEventArgs e) { Label label1; DropDownList dropDownList1; if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) { label1 = (Label)e.Item.FindControl(“label1”); dropDownList1 = (DropDownList)e.Item.FindControl(“dropDownList1”); SqlConnection cn = new SqlConnection(@”Server=.\SQLEXPress;uid=sa;pwd=password;Database=Pubs”); string strSQL = “select title_id from titleauthor where au_id = ‘” + label1.Text + “‘”; SqlCommand cmd = new SqlCommand(strSQL, cn); cn.Open(); SqlDataReader dr = cmd.ExecuteReader(); dropDownList1.DataSource = dr; dropDownList1.DataTextField = “title_id”; dropDownList1.DataBind(); dr.Close(); cn.Close(); } }

发布者：全栈程序员栈长，转载请注明出处：https://javaforall.cn/183930.html原文链接：https://javaforall.cn