SelectCommand with web.config key variable

Question

Looking to select records from my DB in ASP.NET using <SelectCommand> with a var from the web.config.

Can't seem to find the proper syntax to work.

no code behind file or vb code in page, so trying to do in just asp.net page.

SelectCommand="SELECT * FROM ClassesTbl WHERE AppName = <%= ConfigurationManager.AppSettings('AppName') %>"

not a valid SQL statement - need to add as a parameter I think? — BarclayVision
– BarclayVision, Commented Sep 3, 2016 at 21:29

BarclayVision · Accepted Answer · 2016-09-03 21:50:01Z

1

actually found a way to make it work:

added:

<SelectParameters>
    <asp:Parameter Name="getAppName" DefaultValue="<%$ AppSettings:AppName %>"/>
</SelectParameters>

and changed SelectCommand to:

SelectCommand="SELECT * FROM ClassesTbl WHERE AppName = @getAppName"

answered Sep 3, 2016 at 21:50

BarclayVision

8612 gold badges14 silver badges41 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1