Joined
Last Seen
0 Reputation Points
Unknown Quality Score
No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
0 Endorsements
Ranked #107.70K
1 Posted Topic
Solved! I wanted TableName to come from the web.config: [CODE] <asp:SqlDataSource ID="dsMySource" runat="server" SelectCommand=" DECLARE @LocalTable as nvarchar(255) SET @LocalTable = @MyTable DECLARE @mySQL varchar(max) SET @mySQL = 'SELECT * from ' + @LocalTable EXEC (@mySQL) " ........... <SelectParameters> <asp:QueryStringParameter DefaultValue="<%$ appSettings:TableName%>" Name="MyTable" QueryStringField="HOrder" /> </SelectParameters> </asp:SqlDataSource> [/CODE] !!BOOM!!
The End.