datalist中的linkbutton

最新推荐文章于 2014-09-29 09:40:32 发布

weixin_33842328

最新推荐文章于 2014-09-29 09:40:32 发布

阅读量122

点赞数

原文链接：http://www.cnblogs.com/wzhxj/archive/2006/08/22/483321.html

版权

<asp:DataList ID="DataList1" runat="server" RepeatColumns="8" Width="717px" OnItemCommand="DataList1_ItemCommand">
                        <ItemTemplate>
                            <asp:LinkButton ID="LinkButton4" runat="server" CommandArgument='<%# DataBinder.Eval(Container.DataItem,"SMT_ypxxone_id").ToString() %>'><%# DataBinder.Eval(Container.DataItem,"SMT_ypxxone").ToString() %></asp:LinkButton>

                        </ItemTemplate>
                            <HeaderTemplate>
                                <font color=red>请选择分类</font>
                            </HeaderTemplate>
                        </asp:DataList>
protected void DataList1_ItemCommand(object source, DataListCommandEventArgs e)
        {
            DataGrid1.CurrentPageIndex = 0;

ViewState["sql"]="SELECT * FROM product INNER JOIN SMT_ypxxtwo ON product.类别2 = SMT_ypxxtwo.SMT_ypxxtwo_id WHERE product.类别1 = '" + e.CommandArgument.ToString() + "' order by id desc";
dtg("SELECT * FROM product INNER JOIN SMT_ypxxtwo ON product.类别2 = SMT_ypxxtwo.SMT_ypxxtwo_id WHERE product.类别1 = '" + e.CommandArgument.ToString() + "' order by id desc");

            SqlConnection conn = db.cn();
            conn.Open();
            SqlCommand cmd = new SqlCommand("SELECT * FROM SMT_ypxxtwo WHERE SMT_ypxxone_id = '" + e.CommandArgument.ToString() + "'", conn);
            SqlDataAdapter da = new SqlDataAdapter();
            da.SelectCommand = cmd;
            DataSet ds = new DataSet();
            da.Fill(ds);

            DataList2.DataSource = ds;
            DataList2.DataBind();
            ds.Clear();
            conn.Close();
        }

转载于:https://www.cnblogs.com/wzhxj/archive/2006/08/22/483321.html