Anyone know if it’s possible to pass a querystring to define a column in an ASP.net SqlDataSource or some other approach?
The code below doesn’t work and I’m trying to figure out a way to save myself creating muliple pages with individual datasources.
Thanks in advance (I’m just trying to wrap my head around asp.net these days)
[SIZE=2][SIZE=2]
<[/SIZE][/SIZE][SIZE=2][SIZE=2]asp[/SIZE][/SIZE][SIZE=2][SIZE=2]:[/SIZE][/SIZE][SIZE=2][SIZE=2]SqlDataSource[/SIZE][/SIZE][SIZE=2] [/SIZE][SIZE=2][SIZE=2]ID[/SIZE][/SIZE][SIZE=2][SIZE=2]="SqlDataSource1"[/SIZE][/SIZE][SIZE=2] [/SIZE][SIZE=2][SIZE=2]runat[/SIZE][/SIZE][SIZE=2][SIZE=2]="server"[/SIZE][/SIZE][SIZE=2]
[/SIZE][SIZE=2][SIZE=2]ConnectionString[/SIZE][/SIZE][SIZE=2][SIZE=2]="[/SIZE][/SIZE][SIZE=2]<%$ ConnectionStrings:MyDatabase %>[/SIZE][SIZE=2][SIZE=2]"[/SIZE][/SIZE][SIZE=2]
[/SIZE][SIZE=2][SIZE=2]SelectCommand[/SIZE][/SIZE][SIZE=2] [/SIZE][SIZE=2][SIZE=2]=[/SIZE][/SIZE][SIZE=2] [/SIZE][SIZE=2][SIZE=2]"SELECT [Field1], [Field2] WHERE @querycolumn ='1') ORDER BY [Field1]"[/SIZE][/SIZE][SIZE=2] [/SIZE][SIZE=2][SIZE=2]>
[/SIZE][/SIZE][SIZE=2][/SIZE][SIZE=2][SIZE=2]<[/SIZE][/SIZE][SIZE=2][SIZE=2]SelectParameters[/SIZE][/SIZE][SIZE=2][SIZE=2]>
[/SIZE][/SIZE][SIZE=2][/SIZE][SIZE=2][SIZE=2]<[/SIZE][/SIZE][SIZE=2][SIZE=2]asp[/SIZE][/SIZE][SIZE=2][SIZE=2]:[/SIZE][/SIZE][SIZE=2][SIZE=2]QueryStringParameter[/SIZE][/SIZE][SIZE=2] [/SIZE][SIZE=2][SIZE=2]Name[/SIZE][/SIZE][SIZE=2][SIZE=2]="querycolumn"[/SIZE][/SIZE][SIZE=2] [/SIZE][SIZE=2][SIZE=2]QueryStringField[/SIZE][/SIZE][SIZE=2][SIZE=2]="querycolumn"[/SIZE][/SIZE][SIZE=2] [/SIZE][SIZE=2][SIZE=2]Type[/SIZE][/SIZE][SIZE=2][SIZE=2]="String"[/SIZE][/SIZE][SIZE=2] [/SIZE][SIZE=2][SIZE=2]/>
[/SIZE][/SIZE][SIZE=2][/SIZE][SIZE=2][SIZE=2]</[/SIZE][/SIZE][SIZE=2][SIZE=2]SelectParameters[/SIZE][/SIZE][SIZE=2][SIZE=2]>
[/SIZE][/SIZE][SIZE=2][/SIZE][SIZE=2][SIZE=2]</[/SIZE][/SIZE][SIZE=2][SIZE=2]asp[/SIZE][/SIZE][SIZE=2][SIZE=2]:[/SIZE][/SIZE][SIZE=2][SIZE=2]SqlDataSource[/SIZE][/SIZE][SIZE=2][SIZE=2]>
[/SIZE][/SIZE]
