how to change SqlDataSource ConnectionString from code behind in C#.NET. "dsGrdStock" runat= "server" ConnectionString= " " ProviderName= " " >

Add referennce of System.Configuration and write the below code to change it dynamically public void updateConfigFile( string ConnectionString) { //updating config file var XmlDoc = new XmlDocument(); //Loading the Config file var configFile = AppDomain.CurrentDomain.SetupInformation.ConfigurationFile; XmlDoc.Load(configFile); foreach (XmlElement xElement in XmlDoc.DocumentElement) { if (xElement.Name == "connectionStrings" ) { //setting the coonection string xElement.FirstChild.Attributes[ "connectionString" ].Value = ConnectionString; } } //writing the connection string in config file XmlDoc.Save(configFile); ConfigurationManager.RefreshSection( "connectionStrings" ); Just call the above method to change it. Good Luck

Hi Kamrul, You can do something like this. dsGrdStock.ConnectionString = "whateveryouwant" ; I hope this will help you.

Answers

Change SqlDataSource ConnectionString dynamically

Kamrul Hasan

796

how to change SqlDataSource ConnectionString from code behind in C#.NET.

"dsGrdStock" runat="server"
ConnectionString="<%$ ConnectionStrings:dbPOS %>"
ProviderName="<%$ ConnectionStrings:dbPOS.ProviderName %>">

Answers (2)

Next Recommended Forum

Enums conversion

Create DSN using C#

Leaderboard

View all

Mahesh Chand

Vijay Pratap Singh

George

View all

Yesterday's leader

Mahesh Chand

Startup Advisor, Speaker, Author, Architecture, Innovation

Philadelphia (USA)

241.5m

271k

Member of the month

Mark Pelf

Belgrade (Yugoslavia)

187

289.3k

10.5k

500

Speaker of the month

Magnus Mårtensson

ASP.NET, .NET, C#, JavaScript, Azure

Sweden

18.3k

58.5k

Upcoming events

View all

Suggested for you

View all

Kirtesh Shah

Sifad Hussain

Abdul Basith

Uday Dodiya

Sarfaraj Ansari

Forum Statistics

Please welcome our newest member Jhonny Angeles Rivera Mendoza.
3,077,313 users have contributed to 147,418 threads and 483,387
In the past 24 hours, we have 8 new threads, 21 new posts, and 146 new users.
In last week, the most popular thread is 'Case statement Else part Not Working Properly .'.