CREATE A New Project select ClassLibrary name it ConnectionClass.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
namespace ConnectionClass
{
public class Class1
{
}
}
------------------------------------------------------------------
Change the Class1 to your class name say "Connections" as shown below
------------------------------------------------------------------
using System;
using System.Data;
using System.Configuration;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Xml.Linq;
using System.Data.SqlClient;
namespace ConnectionClass
{
public class Connections
{
public static string cmsconnection;
SqlConnection con;
public static string constr
{
get
{
if (cmsconnection == null)
{
cmsconnection = System.Configuration.ConfigurationManager.ConnectionStrings["conn"].ConnectionString.ToString();
}
return cmsconnection;
}
}
public SqlConnection connection
{
get
{
if (con == null)
{
con = new SqlConnection();
con.ConnectionString = constr;
con.Open();
return con;
}
if (con.State == ConnectionState.Closed)
{
con.Open();
}
return con;
}
}
}
}
Save and Build to create Dll file
------------------------------------------------------------------
add referance to ConnectionClass.dll
ConnectionClass.Connections cs=new ConnectionClass.Connections();
Add connection string in web.config
<connectionStrings>
<add name="conn" connectionString="Data Source=AcharyaPC;Initial Catalog=MyTableName;Integrated Security=True" providerName="System.Data.SqlClient"/>
</connectionStrings>
--------------------------------------------------------------------
ENJOY
