/// <summary> /// 返回数据库列表 /// </summary> /// <returns></returns> public ArrayList GetDbList() { ArrayList alDbs = new ArrayList(); SQLDMO.Application sqlApp = new SQLDMO.ApplicationClass(); SQLDMO.SQLServer svr = new SQLDMO.SQLServerClass(); try { svr.Connect(ServerName, UserName, Password); foreach (SQLDMO.Database db in svr.Databases) { if (db.Name != null) { alDbs.Add(db.Name); } } } catch (Exception e) { throw (new Exception("连接数据库出错:" + e.Message)); } finally { svr.Close(); sqlApp.Quit(); } return(alDbs); }
/// <summary> /// �������ݿ��б� /// </summary> /// <returns></returns> public ArrayList GetDbList() { ArrayList alDbs = new ArrayList(); SQLDMO.Application sqlApp = new SQLDMO.ApplicationClass(); SQLDMO.SQLServer svr = new SQLDMO.SQLServerClass(); try { svr.Connect(ServerName, UserName, Password); foreach (SQLDMO.Database db in svr.Databases) { if (db.Name != null) alDbs.Add(db.Name); } } catch (Exception e) { throw (new Exception("�������ݿ�����" + e.Message)); } finally { svr.Close(); sqlApp.Quit(); } return alDbs; }