/// <summary>
/// ȡ��dbmʵ����ʧ�ܷ���null
/// </summary>
/// <param name="s1">������</param>
/// <param name="s2">���ݿ�����</param>
/// <param name="s3">�û���</param>
/// <param name="s4">����</param>
/// <returns></returns>
public static DBManager GetInstance(String s1, String s2, String s3, String s4)
{
DBManager dbm = new DBManager();
dbm.server = s1;
dbm.db = s2;
dbm.user = s3;
dbm.pw = s4;
StringBuilder sb = new StringBuilder("Server=");
sb.Append(s1);
sb.Append(";initial catalog=");
sb.Append(s2);
sb.Append(";UID=");
sb.Append(s3);
sb.Append(";PWD=");
sb.Append(s4);
sb.Append(";Connection Timeout=5");
dbm.conn = new SqlConnection(sb.ToString());
try
{
dbm.conn.Open();
dbm.cmd = new SqlCommand("", dbm.conn);
dbm.cmd.CommandTimeout = 120;
dbm.dap = new SqlDataAdapter();
dbm.dap.SelectCommand = dbm.cmd;
dbm.cb = new SqlCommandBuilder(dbm.dap);
}
catch
{
return null;
}
return dbm;
}
