http://lucky_elove.www1.dotnetplayground.com/ShowList.aspx?id=1http://lucky_elove.www1.dotnetplayground.com/ShowDetail.aspx?id=12912741-070C-41DE-8D08-50C8DDA1F864
解决方案 »
- 【100分】疑难问题,请高手围观,不吝赐教!!!!
- 网页过期怎么弄啊???急啊,来个高手帮个忙!!!!
- 100分求里路径算法
- 求将HTML代码转换为UBB代码的c#正则表达式
- ★有有msdn关于asp.net2.0的help文档的吗?
- 各位大侠帮帮忙呀,这个问题我已经问了很多人了,没有人知道
- CnForums1.2 测试版
- 同样的内容,扩展名不一样,结果也不一样(关于网页编码的问题,内详)
- 有没有编辑asp。net的软件,像dreamweaver
- 怎么输出不了图片只有System.Byte[] ?高手们帮帮忙
- 请问网页中.gif图片是用什么工具做出来的?
- 用asp.net+c#+sql server2000这样的工作岗位工资能有多少呀??
下面就是利用RowFilter属性,将一个DataSet绑定到两个DataGrid的例子代码:<%@ 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("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>