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

884

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

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

Answers (2)

Forum Statistics

Please welcome our newest member Code-G Institute.
3,096,486 users have contributed to 147,391 threads and 483,654
In the past 24 hours, we have 0 new threads, 0 new posts, and 34 new users.
In last week, the most popular thread is 'How do generations (Gen0, Gen1, Gen2, LOH) work in .NET GC?'.

Upcoming Events

View all

AI Agents Conference - 2025

Our Training Programs

View all

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training