Singsys: Best Taxi Booking App Development Company in Singapore (2024)
Taxi Booking App Development Company in Singapore
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:
Mar 14th, 2024
Taxi Booking App Development Company in Singapore
Mar 12th, 2024
The contemporary information technology (IT) landscape is characterised by an exponential growth in data generation, primarily occurring at the network’s edge. This surge poses a challenge to traditional, centralised computing […]
Mar 5th, 2024
How to use Google’s new Gemini AI