Question

你的主机屋数据库是怎么连接上去的，我尝试了好多方法一直都是not alllow to connect

Answer 1

private static String _strConn = "server=.;uid=sa;pwd=sa;database=dbname";

private static SqlConnection _dbConn = new SqlConnection(_strConn);
public static SqlConnection getConnection()
{
if (_dbConn == null)
{
_dbConn = new SqlConnection(_strConn);
_dbConn.Open();
}
else if (_dbConn.State == ConnectionState.Closed || _dbConn.State == ConnectionState.Broken)
{
_dbConn.Close();
_dbConn.ConnectionString = _strConn;
_dbConn.Open();
}
return _dbConn;
}