ASP.NET GridView Page + SqlDataSource

   Default.aspx
 
   ……
   <asp:SqlDataSource ID="SqlDataSource1" runat="server">
   </asp:SqlDataSource>
   <asp:GridView ID="GridView1" runat="server" AllowPaging="true" PagerSettings-PageButtonCount="7">
   </asp:GridView>
   ……
 

 

   Default.aspx.vb
 
   Imports System.Data.SqlClient
 
   Partial Public Class _Default
      Inherits System.Web.UI.Page
 
      Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
         Read()
      End Sub
 
      Sub Read()
         Dim csBuilder As New SqlConnectionStringBuilder()
         csBuilder.DataSource = "."
         csBuilder.InitialCatalog = "Soccer"
         ‘Integrated Security = SSPI
         csBuilder.IntegratedSecurity = True
 
         Dim A As New StringBuilder
         A.Append("SELECT Player.Player_Name, Team.Team_Name, League.League_Name ")
         A.Append("FROM Player INNER JOIN ")
         A.Append("Team ON Player.Team_ID = Team.Team_ID INNER JOIN ")
         A.Append("League ON Team.League_ID = League.League_ID")
 
         SqlDataSource1.ConnectionString = csBuilder.ConnectionString
         SqlDataSource1.SelectCommand = A.ToString
 
         GridView1.DataSourceID = SqlDataSource1.ID
         GridView1.DataBind()
 
         SqlDataSource1.Dispose()
      End Sub
 
   End Class