DataList in GridView

最新推荐文章于 2022-07-04 17:59:12 发布

转载最新推荐文章于 2022-07-04 17:59:12 发布 · 63 阅读

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/RuiLei/archive/2008/01/21/1047628.html

本文介绍了在ASP.NET中如何实现GridView嵌套DataList的方法，包括使用PlaceHolder加载UserControl、直接在DataList中添加数据及UserControl内嵌DataList等三种方案，并详细展示了各方案的实现代码。

GridView嵌套DataList,这里讲述了在DataList中用三种不同载体，加载数据的显示方式

使用PlaceHolder load UserControl的方式
使用直接Add数据到DataList,显示
使用UserControl嵌套DatList的方式

1.使用PlaceHolder load UserControl的方式

WebForm:

<asp:GridView ID="GridView1" runat="server" OnRowDataBound="GridView1_RowDataBound" >
                <Columns>
                    <asp:TemplateField>
                        <ItemTemplate>
                            <%# Eval("Orderid") %>
                        </ItemTemplate>
                    </asp:TemplateField>
                    <asp:TemplateField>
                        <ItemTemplate>
                            <asp:PlaceHolder ID="place" runat="server"></asp:PlaceHolder>
                        </ItemTemplate>
                    </asp:TemplateField>
                </Columns>
</asp:GridView>

UserControl:

<asp:DataList ID="DataList2" runat="server" RepeatDirection="Horizontal" GridLines="Both">
    <ItemTemplate>
        Orderid: <%# Eval("Orderid") %>
        Unitprice:<%#Eval("unitprice") %>
    </ItemTemplate>
</asp:DataList>

WebForm Code Bebind:

首先：Page_Load事件中绑定GridView

然后：GridView_RowDataBound事件中

            IList<String> str = new List<String>();//添加测试数据
            str.Add("ID1");
            str.Add("ID2");
            str.Add("ID3");
            str.Add("ID3");

            if (e.Row.RowIndex > -1)
            {
                for (int i = 0; i < str.Count; i++)
                {
                    if (e.Row.RowIndex == i) //去掉加载的重复项
                    {
                        //第一个方式
                        PlaceHolder pl = e.Row.FindControl("place") as PlaceHolder;
                        WebUserControl1 c = this.Page.LoadControl("WebUserControl1.ascx") as WebUserControl1;

SqlDataAdapter sqlDataAdapter;
DataSet dataSet = new DataSet();

sqlDataAdapter = new SqlDataAdapter(SQL语句, sqlConnection);
sqlDataAdapter.SelectCommand.Parameters.Add("@orderid", SqlDbType.Int).Value = OrderId值

sqlDataAdapter.Fill(dataSet, "[order details]");
c.DataSource = dataSet.Tables["[order details]"];

                        //第一个方式
                        pl.Controls.Add(c);
                    }
                }
            }
        }

UC CodeBebind:

protected void Page_Load(object sender, EventArgs e)
       {
           this.DataList2.DataSource = dataSource;
           this.DataBind();
       }

       private DataTable dataSource;
       public DataTable DataSource
       {
           set
           {
               dataSource = value;
           }
       }

2.使用直接Add数据到DataList,显示

WebForm:

<asp:GridView ID="GridView1" runat="server" OnRowDataBound="GridView1_RowDataBound" >
                <Columns>
                    <asp:TemplateField>
                        <ItemTemplate>
                            <%# Eval("Orderid") %>
                        </ItemTemplate>
                    </asp:TemplateField>
                    <asp:TemplateField>
                        <ItemTemplate>
                            <asp:DataList ID="DataList2" runat="server" RepeatDirection="Horizontal" >
                      <ItemTemplate>
                         Orderid:<%# Eval("Orderid") %>
                         Unitprice:<%#Eval("unitprice") %>
                     </ItemTemplate>
                    <asp:DataList>

                        </ItemTemplate>
                    </asp:TemplateField>
                </Columns>
</asp:GridView>

WebForm Code Bebind:

首先：Page_Load事件中绑定GridView

然后：GridView_RowDataBound事件中

            IList<String> str = new List<String>();//添加测试数据
            str.Add("ID1");
            str.Add("ID2");
            str.Add("ID3");
            str.Add("ID3");

            if (e.Row.RowIndex > -1)
            {
                for (int i = 0; i < str.Count; i++)
                {
                    if (e.Row.RowIndex == i) //去掉加载的重复项
                    {
                        //第二个方式
                  DataList dl = e.Row.FindControl("DataList2") as DataList;

SqlDataAdapter sqlDataAdapter;
DataSet dataSet = new DataSet();

sqlDataAdapter = new SqlDataAdapter(SQL语句, sqlConnection);
sqlDataAdapter.SelectCommand.Parameters.Add("@orderid", SqlDbType.Int).Value = OrderId值

sqlDataAdapter.Fill(dataSet, "[order details]");
c.DataSource = dataSet.Tables["[order details]"];

dl.DataSource = dataSet.Tables["[order details]"];
dl.DataBind();

                    }
                }
            }
        }

3.使用UserControl嵌套DatList的方式

WebForm:

<%@ Register Src="WebUserControl1.ascx" TagName="WebUserControl1" TagPrefix="uc1" %>

                        </ItemTemplate>
                    </asp:TemplateField>
                </Columns>
</asp:GridView>

UserControl:

WebForm Code Bebind:

首先：Page_Load事件中绑定GridView

然后：GridView_RowDataBound事件中

            IList<String> str = new List<String>();//添加测试数据
            str.Add("ID1");
            str.Add("ID2");
            str.Add("ID3");
            str.Add("ID3");

            if (e.Row.RowIndex > -1)
            {
                for (int i = 0; i < str.Count; i++)
                {
                    if (e.Row.RowIndex == i) //去掉加载的重复项
                    {
                        //第三个方式
                  WebUserControl1 c = e.Row.FindControl("WebUserControl1") as WebUserControl1;

SqlDataAdapter sqlDataAdapter;
DataSet dataSet = new DataSet();

sqlDataAdapter = new SqlDataAdapter(SQL语句, sqlConnection);
sqlDataAdapter.SelectCommand.Parameters.Add("@orderid", SqlDbType.Int).Value = OrderId值

sqlDataAdapter.Fill(dataSet, "[order details]");
c.DataSource = dataSet.Tables["[order details]"];

                    }
                }
            }
        }

UC CodeBebind:

protected void Page_Load(object sender, EventArgs e)
       {
           this.DataList2.DataSource = dataSource;
           this.DataBind();
       }

       private DataTable dataSource;
       public DataTable DataSource
       {
           set
           {
               dataSource = value;
           }
       }

转载于:https://www.cnblogs.com/RuiLei/archive/2008/01/21/1047628.html