|
xxx
DataView Binding
by Charles Carroll and Ronda Pederson
Blah Blah.
filename=/experiments/dataviewfeatures/sqlclientgrid.aspx
<%@ Import Namespace="System.Data.sqlclient" %>
<%@ Import Namespace="System.Data" %>
<script language="VB" runat="server">
Sub Page_Load(Src As Object, E As EventArgs)
Dim strConn as string ="server=sql2k1.orcsweb.com;uid=student;pwd=magic"
Dim strSQL as string ="select * from publishers where state='NY'"
Dim Conn as New SQLConnection(strConn)
Dim Cmd as New SQLDataAdapter(strSQL,Conn)
Dim ds As New DataSet()
Conn.Open()
cmd.Fill(ds,"pubs")
Dim dv1 As new DataView(ds.Tables(0))
dv1.Sort = "Address"
dv1.RowFilter = "city='Albany'"
myDataGrid.DataSource = dv1
myDataGrid.DataBind()
Conn.close()
End Sub
</script>
<html><head>
<title>Grid of New York Data</title>
</head>
<body bgcolor="#FFFFFF">
<font face="Verdana"><h3>New York Data</h3></font>
<ASP:DataGrid id="MyDataGrid" runat="server"/>
</body></html>
|