How to Pass Static Sqlconnection in 3Tier Arch using c#

hi use this in separate class ,
public static SqlConnection con = new SqlConnection("Data Source=raj-pc;Initial Catalog=sampleDB;Integrated Security=True");
public static void Open()
{

con.Open();
}
public static void Close()
{
con.Close();
}

raj

Dotnet4ashu, if this helps please login to Mark As Answer. | Alert Moderator

Thanks brother i am very thankful to you i apply it on 3tier as well as on 2tier Arch using only c#................

Himanshu Sharma
If you see Dreams then Get Success On Dreams.....

Dotnet4ashu, if this helps please login to Mark As Answer. | Alert Moderator

Hi,
create a class for connection & write this code

using System.Data.SqlClient;
string strConnection="@server=your server name;initial catalog=your db name;integrated security=true";
public static SqlConnection sqlcon=new SqlConnection(strConnection);
public void ConState()
{
if(sqlcon.State==ConnectionState.Open) //if connection is Open it will close
{
sqlcon.Close();
}
if(sqlcon.State==ConnectionState.Closed)
{
sqlcon.Open();
}

}

Regards,
Denny Kurian

Dotnet4ashu, if this helps please login to Mark As Answer. | Alert Moderator

hi if it is answer mark it so it will be useful to everyone

raj

Dotnet4ashu, if this helps please login to Mark As Answer. | Alert Moderator

Hi try this,
its realy helpful

http://www.dotnetfunda.com/blogs/hmanjarawala/1699/sql-helper-class


Mark this as answer, if it helps you..............

Himanshu Manjarawala
Sr. Software Engineer@AutomationAnywhere
http://fieredotnet.wordpress.com/

Dotnet4ashu, if this helps please login to Mark As Answer. | Alert Moderator