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:
- As an iPhone app developer what you can’t afford to miss is this
- How to implement Custom Notification in iOS App to improve the User Experience
- 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