Weekly Technology Tip : How to make connection with database in a C# window based application using App.config file

 Learn How to make connection with database in a C# window based application using App.config file

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.

Singsys is Singapore based custom website design, web applications 

and mobile application development company. Services include Website, 

Android Apps, iPhone and iPad Apps, CMS based websites using Drupal,

Joomla and Wordpress, Ecommerce solutions based on Magento,

Virtuemart, Ubercart, Prestashop and OSCommerce. Call us at +65-65613900 or email to

 info@singsys.com