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 |