Creating only One Connection String for all Forms in C# -WINDOWS FORMS

Step 1
Open a Windows Forms application in Visual Studio 2010 and right-click on your application name within Solution Explorer then choose "Add" >> "New Item" >> "Application Configuration File".








Step 2

Now the app.config file is added to your Windows Forms application where you can supply a connection string.

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
  <connectionStrings>
    <add name ="Myconnectionstring" connectionString ="Data Source=.;Initial Catalog=pulkit;User ID=sa;Password=Wintellect" />
  </connectionStrings>
</configuration>

Step 3
Now you can use this connection string in multiple Windows Forms. First add a reference to System.Configration and then write the code in the Windows Form.
using System.Configuration;
string connectionString = ConfigurationManager.ConnectionStrings["MyconnectionString"].ConnectionString;











No comments:

Post a Comment