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.
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
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?
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 ;)
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.
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.
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?
Hello Foxlearn Facing an error @config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None); Error number CS0029 : Cannot implicitly convert type 'system.configuration.configuration' to "***** .configuration please help
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?
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
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
+Fox Learn ok thanks!! can i have all your examples insert update delete, user authenticate with sql server including this my email is manguilins@gmail.com thankyou verymuch!!
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?
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
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 ??);
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.
@@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
@@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)
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.
If i use entity framework in my c# project , should i go with the same process as the video ?
Excellent presentation with a solution that works well. Easy to follow. Thank you.
Thank you, now I'm gonna try to do this with my WPF app.
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
Hi thanks so much for your video, but I want to ask how should I do if I use LinQ
Hi thanks for the video. If I may ask is there a way to use two databases in one connectionstring c# winforms? Please help
Excellent man, I love this video....this is something I was looking for...Thanks man
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?
hi what if i use intity frame work what change need in connection string
how is it implemented in the main form?
I want to know how to config firewall to use public ip connection
Great Video
Nice video
Thanks for share this video. that was really helpful and I really enjoyed your explanation
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 ;)
How very clear tutorial, thank you so much.
Thank you so much !
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.
helllo foxlearn
can i request ..how can you retrieve a data in database inserted to combo box or textbox or datagridview using this?
thanks
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.
ok. Thank you for your suggestion
I Want to know that how to implement this configuration page in our project?
please...
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?
You should copy your program to another folder. each time you rebuild your project all data in the debug folder will be deleted.
Thanks.
How to worked with XAF as same as it;
Lesson Please....
OK. Thank you for your suggestion !
Great video!!! Thanks!
Can you show this in web application? Much appreciated!
OK. Thank you for your suggestion.
You forgot to add in the video the reference to the System.Configuration class
thank you very much, that was very helpfull, ans the explaination is wonderful!
Need Help, Make a tutorial showing the use of (two connection strings) connection with Local and Remote database in C # language. Thanks!
Not change
Thank so much
You're welcome. Thank you !
are you a robot? who made this music? I'm impressed....
Hello Foxlearn Facing an error @config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
Error number CS0029 : Cannot implicitly convert type 'system.configuration.configuration' to "***** .configuration
please help
Hello Fox, I have the error here how I can fix that? : 'The SelectCommand property has not been initialized before calling 'Fill'.'
how i can used this tutorial with entity framework?
thanks this is great tutorial
Hi, You can create a config form and use this code to save your connection string when using entity framework, Thank
thanks for the tip
not working on entity framework. please help me
You should use entity framework code first, Thank you
What is the cboServer? I don't understand where that came from.
cboServer is a name of combobox control
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?
Please check your code again. I think you miss something
@@foxlearn i copied all your code but connectionstring variable receive null as i do debugging
Hola, Saludos ! Donde puedo descargar el proyecto ? , Gracias !
Keyword not supported: 'datasource'
Showing this error msg when I click connect button.
its " Data Source={0} " not " DataSource={0} "
Fox learn super
Thank you so much !
can you create a tutorial for vbdotnet?
It can't save the config file in the network installation... please help us to save the config file details in network location
Thanks
I think you should run your app as administrator
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
Hi, You can go app.config to change the connection string. Thanks
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
Hi, Please check your connection string again in the app.config file. remember add reference to System.Configuration.dll. Thank you
why u didn't upload the code in the description ?
You can find demo at foxlearn.com . Thank you !
hi fox learn good day im wondering if how can i use the connection with this tutorial thanks
i mean on how can i use it in selecting updating and etc
Hi, You can view more at: ruclips.net/p/PL-EU0JUF-XD2qtVK0pOkCeWLUbnnnMo0k . Thank you !
+Fox Learn ok thanks!! can i have all your examples insert update delete, user authenticate with sql server including this my email is manguilins@gmail.com thankyou verymuch!!
Thank you!
Wooww..keren = great !
Thank you so much !
Dear sir/madam! I can't save the changes to app.config! Please help me :(
Please check your code again. Try to run your app as administrator. Thank you
Thank you :)
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?
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
This will work once you publish/made a .exe of your application.
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 ??);
Change your connectionstring in the app.config file
Elif connection stringi yapamadim bana yardimci olurmusun?
Unfortunately this method doesn't work for me .. Can you send me source code ?
Yes it is true
Hi, I cant access the file. It is saying that access to the path is denied. Any solution for this will be appreciated.
Hi, You need to select your application run as administrator. Thanks
object reference not set to an instance of an object while saving
Please check your connection string name
dear sir/mam i am getting keyword not supported :"datasource' error please help me to solve while connecting with sa password
Please check your connection string again. You should enter your server name, user name and password of your sql account
It should be "Data Source" and NOT "DataSource"
Thanks
error Keyword not supported: 'datasource'
Showing this error msg when I click connect button.
any body can reply
Excuse me, i did not realize it. Hi, i hope these
You're welcome. Thank you so much
Hello, some tutorial for a login with Facebook.
ok. thank you for your suggestion
Keyword not supported
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.
Me gustaría un vídeo con access 2016 y Vb.net 2017
OK. Thank you for your suggestion. I'll upload all videos using vb.net as soon as possible !
@@foxlearn Thank you
config.ConnectionStrings.ConnectionStrings[key].ConnectionString = 'config.ConnectionStrings.ConnectionStrings[key].ConnectionString'
error: 'System.NullReferenceException'
Please check your connection string in the app.config file. thank you !
@@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
@@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)
thanks
You're welcome!