public class Dbconn
{private static SqlConnection connect = null;
private Dbconn()
{;}
public static SqlConnection GetCon(string constr,bool isconnected )
{
if ((connect == null) || (isconnected))
{
if ( connect != null &&connect.State == ConnectionState.Open)
connect.Close() ;
connect = new SqlConnection();
connect.ConnectionString = constr;
connect.Open();
return connect ;
}
else
{
return connect ;
}
}}
编译通过,调用不成功。
string strsql = "Data Source=localhost;Integrated Security=SSPI;Initial Catalog=northwind";
SqlConnection con = Dbconn.GetCon(strsql,false);
{private static SqlConnection connect = null;
private Dbconn()
{;}
public static SqlConnection GetCon(string constr,bool isconnected )
{
if ((connect == null) || (isconnected))
{
if ( connect != null &&connect.State == ConnectionState.Open)
connect.Close() ;
connect = new SqlConnection();
connect.ConnectionString = constr;
connect.Open();
return connect ;
}
else
{
return connect ;
}
}}
编译通过,调用不成功。
string strsql = "Data Source=localhost;Integrated Security=SSPI;Initial Catalog=northwind";
SqlConnection con = Dbconn.GetCon(strsql,false);
connect.Close() ;写成if ( connect != null)
{
if (connect.State == ConnectionState.Open)
{
connect.Close() ;
}
}试试