新客网WWW.XKER.COM:致力做中国最专业的网络学院!
学院: 操作系统 - 网络应用 - 服务器 - 网络安全 - 工具软件 - 办公软件 - Web开发 - 数据库 - 网页设计 - 图形图像 - 媒体动画 - 硬件学堂 - 存储频道 - QQ专区
您的位置：首页 > 软件开发 > .Net开发 > Asp.net教程 > 正文：如何利用RowFilter 属性从一个dataset中创建两个不同的datagrid

如何利用RowFilter 属性从一个dataset中创建两个不同的datagrid

新客网 XKER.COM 2003-07-12 来源： 收藏本文
Women
NameAgeGender
Staci 22 F
Niki 21 F
Candy 44 F
Erica 32 F
Andrea 23 F
Susan 36 F

Men
NameAgeGender
Alex 24 M
John 39 M
Chad 23 M
Greg 48 M 



<%@ Page Language="VB" %>

<%@ Import Namespace="System.Data" %>

<%@ Import Namespace="System.Data.SqlClient" %>



<script runat="server">

    Sub Page_Load(Sender As Object, E As EventArgs)

    

        Dim myConnection As New SqlConnection(ConfigurationSettings.AppSettings("DSN_aspa"))

        Dim myAdapter As New SqlDataAdapter("SELECT PersonName,PersonAge,PersonGender FROM tblPeople", myConnection)

    

        Dim myDataSet As New DataSet()

    

        Try

            myAdapter.Fill(myDataSet, "People")

    

            Dim myDataView As DataView = myDataSet.Tables("People").DefaultView

        

            myDataView.RowFilter = "PersonGender='F'"

            myFemaleDataGrid.DataSource = myDataView

            myFemaleDataGrid.DataBind()

    

            myDataView.RowFilter = "PersonGender='M'"

            myMaleDataGrid.DataSource = myDataView

            myMaleDataGrid.DataBind()

    Catch myException As Exception

        Response.Write("An error has occurred: " & myException.ToString())

    End Try

    

    End Sub

</script>

<html>

    <head>

    </head>

    <body>

        <form runat="server">

            <p>

            Women<br>

            <asp:datagrid id="myFemaleDataGrid" runat="server" autogeneratecolumns="false" enableviewstate="false">

                <columns>

                        <asp:templatecolumn headertext="Name">

                            <itemtemplate>

                                <span><%# Container.DataItem("PersonName") %></span>

                            </itemtemplate>

                        </asp:templatecolumn>

                        <asp:templatecolumn headertext="Age">

                            <itemtemplate>

                                <span><%# Container.DataItem("PersonAge") %></span>

                            </itemtemplate>

                        </asp:templatecolumn>

                        <asp:templatecolumn headertext="Gender">

                            <itemtemplate>

                                <span><%# Container.DataItem("PersonGender") %></span>

                            </itemtemplate>

                        </asp:templatecolumn>

                </columns>

            </asp:datagrid>

            </p>

            <p>

            Men<br>

            <asp:datagrid id="myMaleDataGrid" runat="server" autogeneratecolumns="false" enableviewstate="false">

                <columns>

                        <asp:templatecolumn headertext="Name">

                            <itemtemplate>

                                <span><%# Container.DataItem("PersonName") %></span>

                            </itemtemplate>

                        </asp:templatecolumn>

                        <asp:templatecolumn headertext="Age">

                            <itemtemplate>

                                <span><%# Container.DataItem("PersonAge") %></span>

                            </itemtemplate>

                        </asp:templatecolumn>

                        <asp:templatecolumn headertext="Gender">

                            <itemtemplate>

                                <span><%# Container.DataItem("PersonGender") %></span>

                            </itemtemplate>

                        </asp:templatecolumn>

                </columns>

            </asp:datagrid>

            </p>

        </form>

    </body>

</html>
【收藏】 【评论】 【推荐】 【投稿】 【打印】 【关闭】
发表评论
（要记得去论坛讨论，点击注册新会员） 匿名评论
评论内容：不能超过250字，需审核后才会公布，请自觉遵守互联网相关政策法规。
阅读排行
专题教程
随机推荐
实用信息推荐