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 |