ASP.NET SQLDataReader + GridView 使用方法

 
ASP.NET SQLDataReader + GridView 使用方法
 

   Default.aspx.vb
 
   Imports System.Data.SqlClient
   Imports System.Text.StringBuilder
 
   Private Sub GetInfo()
 
      Dim connectionString1 As New StringBuilder
      connectionString1.Append("Data Source=.\SqlExpress; ")
      connectionString1.Append("Initial Catalog=Soccer; ")
      connectionString1.Append("Integrated Security=SSPI")
 
      Dim con1 As SqlConnection = New SqlConnection(connectionString1.ToString)
      con1.Open()
 
      Dim SqlString1 As New StringBuilder
      SqlString1.Append("SELECT League_ID AS 'League ID', ")
      SqlString1.Append("League_Name AS 'League Name' FROM dbo.League")
 
      Dim cmd1 As SqlCommand = New SqlCommand(SqlString1.ToString, con1)
 
      Dim dr As SqlDataReader = cmd1.ExecuteReader()
      Dim LeagueDataTable As New DataTable
 
      LeagueDataTable.Load(dr)
      GridView1.DataSource = LeagueDataTable
      GridView1.DataBind()
 
      dr.Dispose()
      cmd1.Dispose()
      con1.Dispose()
 
   End Sub