ASP.net:利用RowFilter属性,将一个DataSet绑定到两个DataGridhttp://www.ninedns.com/asp.net/2007430223347.html
来源:互联网 发布:开源数据库的预研报告 编辑:程序博客网 时间:2024/05/16 11:41
下面就是利用RowFilter属性,将一个DataSet绑定到两个DataGrid的例子代码:
<%@ Page Language="<a href="http://dev.21tx.com/language/vb/" target="_blank">VB</a>" %>
<%@ 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("server=.;uid=sa;pwd=;database=pubs")
Dim myAdapter As New SqlDataAdapter("SELECT au_fname,phone,contract FROM Authors", myConnection)
Dim myDataSet As New DataSet()
Try
myAdapter.Fill(myDataSet, "Test1")
Dim myDataView As DataView = myDataSet.Tables("Test1").DefaultView
myDataView.RowFilter = "contract=false"
myFemaleDataGrid.DataSource = myDataView
myFemaleDataGrid.DataBind()
myDataView.RowFilter = "contract=true"
myMaleDataGrid.DataSource = myDataView
myMaleDataGrid.DataBind()
Catch myException As Exception
Response.Write("错误: " & myException.ToString())
End Try
End Sub
</script>
<html>
<head>
</head>
<body>
<form runat="server" ID="Form1">
<p>
contract[False]:<br>
<asp:datagrid id="myFemaleDataGrid" runat="server" autogeneratecolumns="false" enableviewstate="false">
<columns>
<asp:templatecolumn headertext="Name">
<itemtemplate>
<span><%# Container.DataItem("au_fname") %></span>
</itemtemplate>
</asp:templatecolumn>
<asp:templatecolumn headertext="contract">
<itemtemplate>
<span><%# Container.DataItem("contract") %></span>
</itemtemplate>
</asp:templatecolumn>
<asp:templatecolumn headertext="Phone">
<itemtemplate>
<span><%# Container.DataItem("phone") %></span>
</itemtemplate>
</asp:templatecolumn>
</columns>
</asp:datagrid>
</p>
<p>
contract[True]:<br>
<asp:datagrid id="myMaleDataGrid" runat="server" autogeneratecolumns="false" enableviewstate="false">
<columns>
<asp:templatecolumn headertext="Name">
<itemtemplate>
<span><%# Container.DataItem("au_fname") %></span>
</itemtemplate>
</asp:templatecolumn>
<asp:templatecolumn headertext="contract">
<itemtemplate>
<span><%# Container.DataItem("contract") %></span>
</itemtemplate>
</asp:templatecolumn>
<asp:templatecolumn headertext="Phone">
<itemtemplate>
<span><%# Container.DataItem("phone") %></span>
</itemtemplate>
</asp:templatecolumn>
</columns>
</asp:datagrid>
</p>
</form>
</body>
</html>
<%@ Page Language="<a href="http://dev.21tx.com/language/vb/" target="_blank">VB</a>" %>
<%@ 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("server=.;uid=sa;pwd=;database=pubs")
Dim myAdapter As New SqlDataAdapter("SELECT au_fname,phone,contract FROM Authors", myConnection)
Dim myDataSet As New DataSet()
Try
myAdapter.Fill(myDataSet, "Test1")
Dim myDataView As DataView = myDataSet.Tables("Test1").DefaultView
myDataView.RowFilter = "contract=false"
myFemaleDataGrid.DataSource = myDataView
myFemaleDataGrid.DataBind()
myDataView.RowFilter = "contract=true"
myMaleDataGrid.DataSource = myDataView
myMaleDataGrid.DataBind()
Catch myException As Exception
Response.Write("错误: " & myException.ToString())
End Try
End Sub
</script>
<html>
<head>
</head>
<body>
<form runat="server" ID="Form1">
<p>
contract[False]:<br>
<asp:datagrid id="myFemaleDataGrid" runat="server" autogeneratecolumns="false" enableviewstate="false">
<columns>
<asp:templatecolumn headertext="Name">
<itemtemplate>
<span><%# Container.DataItem("au_fname") %></span>
</itemtemplate>
</asp:templatecolumn>
<asp:templatecolumn headertext="contract">
<itemtemplate>
<span><%# Container.DataItem("contract") %></span>
</itemtemplate>
</asp:templatecolumn>
<asp:templatecolumn headertext="Phone">
<itemtemplate>
<span><%# Container.DataItem("phone") %></span>
</itemtemplate>
</asp:templatecolumn>
</columns>
</asp:datagrid>
</p>
<p>
contract[True]:<br>
<asp:datagrid id="myMaleDataGrid" runat="server" autogeneratecolumns="false" enableviewstate="false">
<columns>
<asp:templatecolumn headertext="Name">
<itemtemplate>
<span><%# Container.DataItem("au_fname") %></span>
</itemtemplate>
</asp:templatecolumn>
<asp:templatecolumn headertext="contract">
<itemtemplate>
<span><%# Container.DataItem("contract") %></span>
</itemtemplate>
</asp:templatecolumn>
<asp:templatecolumn headertext="Phone">
<itemtemplate>
<span><%# Container.DataItem("phone") %></span>
</itemtemplate>
</asp:templatecolumn>
</columns>
</asp:datagrid>
</p>
</form>
</body>
</html>
- ASP.net:利用RowFilter属性,将一个DataSet绑定到两个DataGridhttp://www.ninedns.com/asp.net/2007430223347.html
- 利用RowFilter属性,将一个DataSet绑定到两个DataGrid
- 利用RowFilter属性,将一个DataSet绑定到两个DataGrid
- 利用RowFilter属性,将一个DataSet绑定到两个DataGrid
- 利用RowFilter属性,将一个DataSet绑定到两个DataGrid
- ASP.NET中存取图片到数据库的示例(转载http://www.knowsky.com/3257.html)
- http://www.soaspx.com/dotnet/asp.net/tech/tech_20100928_5785.html
- Asp.net中如何将DataSet写入xml文件,及如何将xml读出来绑定到DataGrid(原创)
- Asp.net中如何将DataSet写入xml文件,及如何将xml读出来绑定到DataGrid
- Asp.net中如何将DataSet写入xml文件,及如何将xml读出来绑定到DataGrid
- 将Dataset数据导出到Excel中(ASP.NET/C#)
- 将Dataset数据导出到Excel中(ASP.NET/C#)
- ASP.NET 绑定DataSet中的多个表
- 一个PDF合并操作实现类,利用iTextSharp控件实现(http://www.diybl.com/course/4_webprogram/asp.net/asp_netxl/2008109/149644.html)
- ASP.NET对数据进行HTML编码将其绑定到DrowdownList并解码的解决方案
- asp.net 绑定到JAVASCRIPT
- ASP.NET 下将Menu绑定到数据库
- ASP.NET - 将表格控件绑定到 XmlDataSource 控件
- 如何在托管环境下释放COM对象
- java Mustang 的脚本活力
- log explorer讀取日志注意事項
- 关于vc调试出现One or more breakpoints cannot be set and have been disabled解决方法。
- C#图片处理之:给你的图片打上LOGO
- ASP.net:利用RowFilter属性,将一个DataSet绑定到两个DataGridhttp://www.ninedns.com/asp.net/2007430223347.html
- string.Concat的使用
- Reed–Solomon error correction
- 就这么讲
- web.config 配置文件
- 无题
- Checking Server Performance with Windows Media Load Simulator
- 同Sohu一样变态的Bokee
- 在接口上应用访问控制列表