<%@ Page Language="vb" Debug="true" %> <%@ Import Namespace="System.Data" %> <%@ Import Namespace="System.Data.SqlClient" %> <html> <script language="VB" runat="server"> Sub Page_Load(Src As Object, E As EventArgs) Dim myConnection As SqlConnection myConnection = New SqlConnection("server=localhost;" _ & "database=数据库;USER ID=sa;PWD=") Dim myCommand As SqlDataAdapter = New SqlDataAdapter("SELECT *" _ & " FROM 表", myConnection) Dim ds As DataSet = New DataSet() myCommand.Fill(ds) Dim view As DataView = ds.Tables(0).DefaultView view.Sort = sortField & " ASC" MyDataGrid.DataSource = view MyDataGrid.DataBind() End Sub </script><body> <%-- Display the data in the body of the page. --%> <h3><font face="Verdana">Sorting Data in a DataGrid Control</font></h3> <%-- Within a form, create a DataGrid control and initialize its attributes. --%> <form runat="server"> <ASP:DataGrid id="MyDataGrid" runat="server" OnSortCommand="MyDataGrid_Sort" Width="700" BackColor="#ccccff" BorderColor="black" ShowFooter="false" CellPadding=3 CellSpacing="0" Font-Name="Verdana" Font-Size="8pt" HeaderStyle-BackColor="#aaaadd" AllowSorting="true" /> </form> </body> </html>
"Data Source=mySQLDB;" & _
"User Id=myUsername;" & _
"Password=myPassword"
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<html>
<script language="VB" runat="server">
Sub Page_Load(Src As Object, E As EventArgs)
Dim myConnection As SqlConnection
myConnection = New SqlConnection("server=localhost;" _
& "database=数据库;USER ID=sa;PWD=")
Dim myCommand As SqlDataAdapter = New SqlDataAdapter("SELECT *" _
& " FROM 表", myConnection)
Dim ds As DataSet = New DataSet()
myCommand.Fill(ds)
Dim view As DataView = ds.Tables(0).DefaultView
view.Sort = sortField & " ASC"
MyDataGrid.DataSource = view
MyDataGrid.DataBind()
End Sub
</script><body>
<%-- Display the data in the body of the page. --%>
<h3><font face="Verdana">Sorting Data in a DataGrid Control</font></h3>
<%-- Within a form, create a DataGrid control and initialize its
attributes. --%>
<form runat="server">
<ASP:DataGrid id="MyDataGrid" runat="server"
OnSortCommand="MyDataGrid_Sort"
Width="700"
BackColor="#ccccff"
BorderColor="black"
ShowFooter="false"
CellPadding=3
CellSpacing="0"
Font-Name="Verdana"
Font-Size="8pt"
HeaderStyle-BackColor="#aaaadd"
AllowSorting="true"
/>
</form>
</body>
</html>