ASP.NET SQLDataSource + GET QueryString + DetailsView

 
ASP.NET SQLDataSource + GET QueryString + DetailsView
 

   Default.aspx
 
   <asp:SqlDataSource ID="SqlDataSource1" runat="server" />
   <asp:DetailsView ID="DetailsView1" runat="server"
   DataSourceID="SqlDataSource1" />
 

 

   Default.aspx.vb
 
   If Request.QueryString("id") <> "" Then
 
      SqlDataSource1.ConnectionString = "Data Source=.\SqlExpress;"
      SqlDataSource1.ConnectionString &= "Initial Catalog=Soccer; "
      SqlDataSource1.ConnectionString &= "Integrated Security=SSPI"
 
      SqlDataSource1.SelectCommand = "SELECT League_ID AS 'League ID', League_Name AS 'League Name' " & _
      "FROM dbo.League WHERE League_ID = " & Request.QueryString("id")
 
   End If