Use App.config file to make connection with database in C# window based Applications


Creating a database connection string from app.config is a very common practice used in C# windows based application. Follow these simple steps to make connection with database in C# window based application using App.config file.

 

Step1. Open Visual Studio and create a new Windows application. (Path : Start -> All Programs -> Microsoft Visual Studio 2010-> Microsoft Visual Studio 2010)

 

Step2. Add a new Application Configuration file App.config file to the project.

 

Step3. Provide the connection string name, database name and system related information in the App.config file.

 

<configuration>

<connectionStrings>

<add name=”customConnection” connectionString=”Data Source=Custom-PC;Initial Catalog=customDB;User Id=sa;Password=” providerName=”System.Data.SqlClient”/>

</connectionStrings>

</configuration>

 

 

Step4.  Making a separate connection class.

 

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Data.SqlClient;

using System.Configuration;

namespace customproject

{

public class Class_custom

{

public SqlConnection con ;

public SqlCommand cmd;

public Class_custom()

{

con = new SqlConnection(ConfigurationManager.ConnectionStrings["customConnection "].ConnectionString);

con.Open();

cmd = new SqlCommand();

cmd.Connection = con;

}

}

}

 

Using above code, the user can make connection with database in a C# window using App.config file.

 

Find us on Google+