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

[@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.

[@abdulmalik1389]

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

[@rafaelferreira7408]

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

[@JuanRamirez-uq1ct]

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

[@WillGab]

How very clear tutorial, thank you so much.

[@foxlearn]

Thank you so much !

[@dailyquran2072]

Great Video

[@nboooly]

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

[@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

[@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 ;)

[@rockyivic]

Great video!!! Thanks!

[@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.

[@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

[@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

[@CarlosRivera-xu1zf]

Nice video

[@jaime2911]

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

[@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

[@fawazaliaskar]

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

[@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?

[@theg4meover988]

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

[@lps3026]

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

[@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.

[@SystemServer]

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

[@foxlearn]

OK. Thank you for your suggestion !

[@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

[@md.rezaulkarim]

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

[@elhoucineawixor3072]

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

[@bongemhoangtu2468]

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

[@ybscambo6975]

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

[@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

[@johnchen0213]

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

[@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?

[@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

[@panda3131]

how is it implemented in the main form?

[@dailyquran2072]

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

[@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.

[@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!!

[@shooterrick1]

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

[@foxlearn]

cboServer is a name of combobox control

[@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?

[@harysetiawan3005]

Wooww..keren = great !

[@foxlearn]

Thank you so much !

[@TanNguyen-wd1sp]

Thank so much

[@foxlearn]

You're welcome. Thank you !

[@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

[@noobz186]

Can you show this in web application? Much appreciated!

[@foxlearn]

OK. Thank you for your suggestion.

[@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

[@homeyasamal8474]

Fox learn super

[@foxlearn]

Thank you so much !

[@FelixSamora]

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

[@samael8100]

can you create a tutorial for vbdotnet?

[@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

[@thong.na2510]

Thank you!

[@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

[@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"

[@Rasim_93]

Thank you :)

[@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

[@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

[@وساماسماعيلعمر]

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

[@تكنولوجياومنوعات]

Yes it is true

[@nouriyacine8823]

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

[@foxlearn]

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

[@fademaydarkness1017]

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

[@foxlearn]

Please check your connection string name

[@j.r.4938]

Hello, some tutorial for a login with Facebook.

[@foxlearn]

ok. thank you for your suggestion

[@gilbertoasuaje6763]

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

[@foxlearn]

You're welcome. Thank you so much

[@Saobranaung]

Thanks

[@goodluckcomputershorthandc4305]

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

[@goodluckcomputershorthandc4305]

any body can reply

[@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

[@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.

[@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)

[@softer.prakashmishra8040]

Keyword not supported

[@hadirotafoua5381]

thanks

[@foxlearn]

You're welcome!