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. Watch the below video or follow the 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.

You may be interested in:

• No, the Mobile App development Cost in Singapore is less than you think
• Android App: Battery Optimization Best Practices for Zero Compromise on Performance
• Use Mapkit framework to create a custom annotation view over map view
• Use GestureOverlayView in Android for free hand drawing
• Convert the PDF into images in objective C
• Best Android Apps for 2016-2017 Stored in Play store