gridview模板列绑定gridview

最新推荐文章于 2023-07-08 15:12:34 发布

原创最新推荐文章于 2023-07-08 15:12:34 发布 · 4.4k 阅读

3 ·

CC 4.0 BY-SA版权

文章标签：

#asp #server #object #list #div

asp.net 专栏收录该内容

4 篇文章

订阅专栏

本文介绍了一个使用ASP.NET进行数据绑定的例子，其中包括了两个SqlDataSource组件分别用于获取产品列表和订单详情，以及一个GridView用来展示数据并实现子项数据的动态加载。

<form id="form1" runat="server">
    <div>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>"
            SelectCommand="SELECT top 5 [ProductID], [ProductName] FROM [Alphabetical list of products]">
        </asp:SqlDataSource>
             <br />
         <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>"
            SelectCommand="SELECT * FROM [Order Details] where productid=@id">
        </asp:SqlDataSource>
                    </div>
        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="ProductID"
            DataSourceID="SqlDataSource1">
            <Columns>
                <asp:BoundField DataField="ProductID" HeaderText="ProductID" InsertVisible="False"
                    ReadOnly="True" SortExpression="ProductID" />
                <asp:BoundField DataField="ProductName" HeaderText="ProductName" SortExpression="ProductName" />
                <asp:TemplateField HeaderText="detail">
                    <ItemTemplate>
                           
                        <asp:GridView ID="GridView2" runat="server">
                        </asp:GridView>
                    </ItemTemplate>
                </asp:TemplateField>
            </Columns>
        </asp:GridView>
    </form>

    Protected Sub GridView1_RowDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs) Handles GridView1.RowDataBound
        If e.Row.RowType = DataControlRowType.DataRow Then
            SqlDataSource2.SelectParameters.Clear()

            SqlDataSource2.SelectParameters.Add("id", e.Row.Cells(0).Text)
            'SqlDataSource2.DataBind()
            Dim g As GridView
            g = e.Row.Cells(2).FindControl("gridview2")
            g.DataSource = Me.SqlDataSource2
            g.DataBind()

End If
End Sub