Can we access connection string from session variable in SqlDataSource Control?

Question

I have four database on same server, I am using SqlDataSource Control to bind grid view in my application.And I have implemented a drop-down base on its item selection connection string is saved in a session variable. but I don't know how to pass this session variable in connctionstring property of SqlDataSource Control

<asp:SqlDataSource ID="dsMyAlarm" runat="server" ConnectionString="<%$ ConnectionStrings:AlarmDirectorDTUConnectionString %>"  SelectCommand="AD_FetchAlarmSubscriptionsByUserID" SelectCommandType="StoredProcedure">
     <SelectParameters>
                <asp:SessionParameter DefaultValue="0" Name="ContactId" SessionField="CurrentUser" Type="Int32" />
      </SelectParameters>
 </asp:SqlDataSource>

In This property I want to pass a session variable

ConnectionString="<%$ ConnectionStrings:AlarmDirectorDTUConnectionString %>"

Is it possible? or can i achive this by other way please suggest me I am open for suggestion

Balaji Marimuthu · Accepted Answer · 2016-12-08 07:16:03Z

1

You could bind the session variable in code behind page_load.

dsMyAlarm.connectionString=Session["constr"];

or refer to the document data binding expression.https://support.microsoft.com/en-in/kb/976112

answered Dec 8, 2016 at 7:16

Balaji Marimuthu

2,06814 silver badges14 bronze badges

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

Collectives™ on Stack Overflow

Can we access connection string from session variable in SqlDataSource Control?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related