以下是示例代码:
ASP.net页面:
VB.net页面:
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If Not IsPostBack Then
BindGrid()
End If
End Sub
Sub BindGrid()
Dim connectionString As String = "Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Northwind.mdf;Integrated Security=True;User Instance=True"
Dim sql As String = "SELECT OrderID, OrderDate, CustomerName, ShipCity FROM Orders"
Dim conn As New SqlConnection(connectionString)
Dim da As New SqlDataAdapter(sql, conn)
Dim ds As New DataSet()
da.Fill(ds, "Orders")
GridView1.DataSource = ds.Tables("Orders")
GridView1.DataBind()
End Sub
Protected Sub GridView1_Sorting(ByVal sender As Object, ByVal e As