C# Tutorial - Change ConnectionString at Runtime with App.config | FoxLearn

How to change connectionstring dynamically in c# connect to sql server database example. The c# basics beginner course is a free c# tutorial series that helps beginning programmers learn the basics of the c# programming language
Website: foxlearn.com
Through this video you will learn the following topics:
How to connect sql server database in c# windows application.
Next, create a database connection in c# with sql server, then change connection string dynamically c# entity framework. How to use c# configurationmanager set connection string with entity framework change connection string at runtime.
Learn sql server connection string example, then use c# configurationmanager to get connection string c#, through the example you can learn how to get connection string from sql server.
Learn how to connect sql database in c# and how to change connection string in app.config dynamically in c#
Next, change initial catalog in connection string c# and change data source connection string c#.
How to use connection string in app.config c# windows application to change connection string at runtime c#.
The best way to read the app.config connection string c#, then change the connection string dynamically for sqldatasource during run time.
Get and set c# application settings in runtime and learn how to read connectionstring from app config file in Visual Studio. Using the app.config in c# for creating global connectionstring and how to connect database in c#.

[@sistemasaprovados]

Muito Obrigado, você me fez dar um salto alto em meu projeto, nem sei como te agradecer, faltava somente isso para automatizar as configurações de conexão do meu sistema. Thank you very much, you made me take a high leap in my project, I don't even know how to thank you, that was all I needed to automate my system's connection settings.

[@Microjam]

Excellent presentation with a solution that works well. Easy to follow. Thank you.

[@rafaelferreira7408]

Thank you, now I'm gonna try to do this with my WPF app.

[@deepakbhanushali1]

Can you provide same thing for Access Database , I have 2 set of database 1st one is companymaster, 2nd is datamaster where datamaster will select database as per company name and financial year selected from companymaster

[@abdulmalik1389]

Excellent man, I love this video....this is something I was looking for...Thanks man

[@hasmukhsavaliya4657]

Hello, the XML configuration file (.exe.Config) file under bin > Debug folder is changed with new connection parameter using your solution, but there is no effect of changed connection string the program always using the old connection string when running again, Please help/correct ;)

[@carlvergara7457]

Hi it says The type initializer for 'System.Data.SqlClient.SqlConnection' threw an exception. I already check my app.config but stll i get that error, Thanks for the response. Please give me response because I badly need it.

[@ybscambo6975]

I want to know how to config firewall to use public ip connection

[@AngelPatxiRodriguezFernandez]

It works correctly in debug but when installing it in Program Files it does not work. It does not change the connection string. There is no permission to edit the file. Any suggestion?

[@JuanRamirez-uq1ct]

Thanks for share this video. that was really helpful and I really enjoyed your explanation

[@nboooly]

thank you very much, that was very helpfull, ans the explaination is wonderful!

[@SiakNiTonying]

helllo foxlearn can i request ..how can you retrieve a data in database inserted to combo box or textbox or datagridview using this? thanks

[@rockyivic]

Great video!!! Thanks!

[@TanNguyen-wd1sp]

Thank so much

[@foxlearn]

You're welcome. Thank you !

[@WillGab]

How very clear tutorial, thank you so much.

[@foxlearn]

Thank you so much !

[@dailyquran2072]

Great Video

[@theg4meover988]

If i use entity framework in my c# project , should i go with the same process as the video ?

[@marcusshamase2050]

Hi thanks for the video. If I may ask is there a way to use two databases in one connectionstring c# winforms? Please help

[@jaime2911]

You forgot to add in the video the reference to the System.Configuration class

[@lps3026]

Hi thanks so much for your video, but I want to ask how should I do if I use LinQ

[@CarlosRivera-xu1zf]

Nice video

[@fawazaliaskar]

hi what if i use intity frame work what change need in connection string

[@khanalzai20]

i am getting this 2 errors Could not find schema information for the element connectionString the type initializer for system.data.sqlconnection threw an exception

[@foxlearn]

Hi, Please check your connection string again in the app.config file. remember add reference to System.Configuration.dll. Thank you

[@md.rezaulkarim]

Keyword not supported: 'datasource' Showing this error msg when I click connect button.

[@elhoucineawixor3072]

its " Data Source={0} " not " DataSource={0} "

[@matigarimanjirungi59]

Hello Foxlearn Facing an error @config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None); Error number CS0029 : Cannot implicitly convert type 'system.configuration.configuration' to "***** .configuration please help

[@hadirotafoua5381]

thanks

[@foxlearn]

You're welcome!

[@bongemhoangtu2468]

Hello Fox, I have the error here how I can fix that? : 'The SelectCommand property has not been initialized before calling 'Fill'.'

[@islam_TVs]

Can you make a tutorial on How to make Setup File of a C# Windows Application with SQL server database. Database created on SSMS and connected through connection string.

[@foxlearn]

ok. Thank you for your suggestion

[@thong.na2510]

Thank you!

[@dailyquran2072]

I Want to know that how to implement this configuration page in our project? please...

[@afzalhossainbd]

Thanks for the nice video. After saving the settings, I have to close and re-open the program otherwise saved settings do not work even I can see .conf already saved with new information! Is there anything that I can do: save and setting applies?

[@foxlearn]

You should copy your program to another folder. each time you rebuild your project all data in the debug folder will be deleted.

[@SiakNiTonying]

Error 1 'Connection.Sqlhelper.IsConnection.get': not all code paths return a value c:\users\anthony\documents\visual studio 2013\Projects\Connection\Connection\SQLHELPER.cs 22 13 Connection what to do?

[@panda3131]

how is it implemented in the main form?

[@Rasim_93]

Thank you :)

[@SystemServer]

Thanks. How to worked with XAF as same as it; Lesson Please....

[@foxlearn]

OK. Thank you for your suggestion !

[@johnchen0213]

are you a robot? who made this music? I'm impressed....

[@FelixSamora]

Hola, Saludos ! Donde puedo descargar el proyecto ? , Gracias !

[@queirozquery5734]

Need Help, Make a tutorial showing the use of (two connection strings) connection with Local and Remote database in C # language. Thanks!

[@foxlearn]

Not change

[@ngocluunguyenbao4490]

Dear sir/madam! I can't save the changes to app.config! Please help me :(

[@foxlearn]

Please check your code again. Try to run your app as administrator. Thank you

[@MrSyed33]

Hello Fox, The code runs smoothly but my connection string is not updated when i press the save button even though the message box says that it has been successfully saved. pls help

[@johnreytungul4188]

This will work once you publish/made a .exe of your application.

[@homeyasamal8474]

Fox learn super

[@foxlearn]

Thank you so much !

[@harysetiawan3005]

Wooww..keren = great !

[@foxlearn]

Thank you so much !

[@gilbertoasuaje6763]

Once it is already packaged with the VisualStudio wrapper, could you use this tool to change the configuration of the connection string? Or is there a way to create a text file and that there is the connection string? Thanks for these videos, they helped me a lot. and I apologize for my English

[@foxlearn]

Hi, You can go app.config to change the connection string. Thanks

[@shehrozimran]

HI Fox learn Team, string connectionString = string.Format("Data Source={0};Initial Catalog={1};User ID={2};Password={3};", txtcomboBox.Text, Databasetxt.Text, usertxt.Text, passwordtxt.Text); in this code my connection STring return null . Can you tell me why?

[@foxlearn]

Please check your code again. I think you miss something

[@shehrozimran]

@@foxlearn i copied all your code but connectionstring variable receive null as i do debugging

[@RamanjaneyuluKondaru]

It can't save the config file in the network installation... please help us to save the config file details in network location Thanks

[@foxlearn]

I think you should run your app as administrator

[@samael8100]

can you create a tutorial for vbdotnet?

[@noobz186]

Can you show this in web application? Much appreciated!

[@foxlearn]

OK. Thank you for your suggestion.

[@user-hl1ss9lx4u]

Unfortunately this method doesn't work for me .. Can you send me source code ?

[@user-ym8fn3bk6l]

Yes it is true

[@Ranjithkumar-tr1mh]

Hi, I cant access the file. It is saying that access to the path is denied. Any solution for this will be appreciated.

[@foxlearn]

Hi, You need to select your application run as administrator. Thanks

[@shooterrick1]

What is the cboServer? I don't understand where that came from.

[@foxlearn]

cboServer is a name of combobox control

[@elifgozdeklc9694]

How can the current connection string be called in a different form? How to associate with an SQL query? SqlCommand cmd= new SqlCommand("Select HOST from BAGLANTI where ID=@p1", helper ??);

[@foxlearn]

Change your connectionstring in the app.config file

[@ArunTr]

Elif connection stringi yapamadim bana yardimci olurmusun?

[@michaelmashigwana4669]

Please help with this : Using windows form project write a C# application and make use of CRUD (Create, Read, Update and Delete) to include a Search function, Read function, Update function and delete function. Take Students as a Data Source (with its properties) and perform LINQ queries on this. All the CRUD procedures should be done on the C# IDE and update the information on the SQL Server database as well. Students are allowed to use different properties and colors, to make the application more real world like.

[@softer.prakashmishra8040]

Keyword not supported

[@DaveJamesTech]

how i can used this tutorial with entity framework? thanks this is great tutorial

[@foxlearn]

Hi, You can create a config form and use this code to save your connection string when using entity framework, Thank

[@DaveJamesTech]

thanks for the tip

[@DaveJamesTech]

not working on entity framework. please help me

[@foxlearn]

You should use entity framework code first, Thank you

[@Saobranaung]

Thanks

[@goodluckcomputershorthandc4305]

error Keyword not supported: 'datasource' Showing this error msg when I click connect button.

[@goodluckcomputershorthandc4305]

any body can reply

[@nouriyacine8823]

why u didn't upload the code in the description ?

[@foxlearn]

You can find demo at foxlearn.com . Thank you !

[@sherwinmanguilin1173]

hi fox learn good day im wondering if how can i use the connection with this tutorial thanks

[@sherwinmanguilin1173]

i mean on how can i use it in selecting updating and etc

[@foxlearn]

Hi, You can view more at: kzbin.info/aero/PL-EU0JUF-XD2qtVK0pOkCeWLUbnnnMo0k . Thank you !

[@sherwinmanguilin1173]

+Fox Learn ok thanks!! can i have all your examples insert update delete, user authenticate with sql server including this my email is [e-mail] thankyou verymuch!!

[@rahulsharma-tm4ye]

dear sir/mam i am getting keyword not supported :"datasource' error please help me to solve while connecting with sa password

[@foxlearn]

Please check your connection string again. You should enter your server name, user name and password of your sql account

[@adelmerhej4194]

It should be "Data Source" and NOT "DataSource"

[@fademaydarkness1017]

object reference not set to an instance of an object while saving

[@foxlearn]

Please check your connection string name

[@gilbertoasuaje6763]

Excuse me, i did not realize it. Hi, i hope these

[@foxlearn]

You're welcome. Thank you so much

[@j.r.4938]

Hello, some tutorial for a login with Facebook.

[@foxlearn]

ok. thank you for your suggestion

[@Jesus72188]

Me gustaría un vídeo con access 2016 y Vb.net 2017

[@foxlearn]

OK. Thank you for your suggestion. I'll upload all videos using vb.net as soon as possible !

[@Jesus72188]

@@foxlearn Thank you

[@charli384]

config.ConnectionStrings.ConnectionStrings[key].ConnectionString = 'config.ConnectionStrings.ConnectionStrings[key].ConnectionString' error: 'System.NullReferenceException'

[@foxlearn]

Please check your connection string in the app.config file. thank you !

[@cut1e_]

@@foxlearn An unhandled exception of type 'System.NullReferenceException' Error in this line config.ConnectionStrings.ConnectionStrings[key].ConnectionString = value; What exactly do I need to fix? connectionString="Data Source=DESKTOP-65QMQGS\SQLEXPRESS;Initial Catalog=uchhet_izm;Integrated Security=True?;" Please answer me, it is very important for me

[@cut1e_]

@@foxlearn I found my mistake, I had a different form name. In general, thank you very much for the video, I suffered for a very long time until I found you)