Defining ConnectionString in asp SqlDataSource

asp.net, c#

Solution

Your web.config should be like below:

<appSettings>
<add key="ConnStr" value="Server=yourservername;Database=yourdatabasename;UID=yourusername;Password=youruserpassword"/>
</appSettings>

And your .aspx file should like following:

<asp:GridView ID="grd" runat="server" DataSourceID="SqlDataSource2">
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ appSettings:ConnStr %>" SelectCommand="SELECT * FROM ticketmaster"></asp:SqlDataSource>

Problem

I have my database connectivity which I define under `<appSettings>` in `web.comfig`: ``` <appSettings> <add key="ConnStr" value="Data Source=dsk-159\SQLEXPRESS;Initial Catalog=master;Integrated Security=True"/> </appSettings> ``` But the problem is that I am unable to access it from my aspx page as I am trying like this ``` <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:goldsConnectionString %>" SelectCommand="SELECT distinct TechnologyId , [TechnologyName], [ChildId] FROM [TreeTable] where childid is null AND technologyid in(@hid1)"> <SelectParameters> <asp:ControlParameter ControlID="hid1" Name="hid1" DefaultValue="23" /> </SelectParameters> ``` In place of `<connectionStrings>` I want to define it in `<appSettings>` Plesae tell the correct syntax.

Original source