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.




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





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


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+