Defining ConnectionString in asp SqlDataSource

Question

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.

rene · Accepted Answer · 2018-01-07 15:41:41Z

5

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>

edited Jan 7, 2018 at 15:41

rene

42.6k78 gold badges122 silver badges166 bronze badges

answered Apr 24, 2013 at 9:15

Pankaj

7054 silver badges3 bronze badges

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

Comments

DGibbs · Accepted Answer · 2013-04-24 08:47:52Z

5

You know you can set the connection string in the code behind rather than inline, it's much cleaner.

SqlDataSource2.ConnectionString = 
System.Configuration.ConfigurationManager.AppSettings["ConnStr"];

Consider reading up on ConfigurationManger.AppSettings

answered Apr 24, 2013 at 8:47

DGibbs

14.7k7 gold badges49 silver badges89 bronze badges

Comments

David · Accepted Answer · 2013-04-24 08:57:23Z

1

Try to change the aspx part to this:

<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:ConnStr %>" 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>

I have done 2 things:

removed the tags.
changed the connection string name to match the name in the web.config
(goldsConnectionString-->ConnStr)

edited Apr 24, 2013 at 8:57

answered Apr 24, 2013 at 8:52

David

4321 gold badge7 silver badges16 bronze badges

4 Comments

golds Over a year ago

Thanks for Reply.i done by code side. Actually i have defined my connection string in AppSetting in webconfig. so that was trying to acces from aspx page as i am unable to find from aspx so i done it on code behind like SqlDataSource2.ConnectionString = System.Configuration.ConfigurationManager.AppSettings["ConnStr"];

David Over a year ago

I believe that my solution should work without the changes on the code side but if you can make changes on the code side (like @DGibbs answer) it's better solution. anyway, you should mark the answer that worked for you :-)

golds Over a year ago

Hi David I tried the way u told <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:ConnStr %>" 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></asp:SqlDataSource> but i am getting error that The connection name 'ConnStr' was not found in the applications configuration or the connection string is empty.

David Over a year ago

your web.config contains the <b> tags?

Necvetanov · Accepted Answer · 2017-05-29 08:07:22Z

0

you can set the connection string in your code-behind page

SqlDataSource2.ConnectionString =
System.Configuration.ConfigurationManager.AppSttings["ConnStr"];

edited May 29, 2017 at 8:07

Necvetanov

4044 silver badges17 bronze badges

answered Apr 24, 2013 at 11:26

Sandeep Dhanush

11 bronze badge

Collectives™ on Stack Overflow

Defining ConnectionString in asp SqlDataSource

4 Answers 4

Comments

Comments

4 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related