|
|
|
|
利用RowFilter属性，将一个DataSet绑定到两个DataGrid |
|
|
|
作者：未知 来源：月光软件站 加入时间：2005-2-28 月光软件站 |
| 利用RowFilter属性，将一个DataSet绑定到两个DataGrid |
作者：孟宪会 出自：【孟宪会之精彩世界】 发布日期：2003年5月15日 8点22分10秒
|
|
下面就是利用RowFilter属性，将一个DataSet绑定到两个DataGrid的例子代码： <![CDATA[<%@ 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") %><img border="0" src="down_info.asp?id=30844" width="1" height="1"><br><br></td>
</tr>
<tr>
<td width="100%" bgcolor="#CCCCCC" height="1"></td>
</tr>
<tr>
<td width="100%"><br><b>相关文章</b>：<p><b>相关软件</b>：</td>
</tr>
</table>
</td>
</tr>
</table>
</center>
</div>
<center><script type="text/javascript" src="../bottom.js"></script></center>
</body>
</html>]]> | | |
本类阅读TOP10