/// <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; }