Example #1
0
 /// <summary>
 /// ȡ�����ݿ������еı���
 /// </summary>
 /// <param name="login">��¼</param>
 /// <returns>��������</returns>
 public List<string> getAllTables(string connectString)
 {
     List<string> ret = new List<string>();
     Base_DbOperate DbOperate = new Base_DbOperate(connectString);
     if (!DbOperate.Open())
         return null;
     DataTable dt = DbOperate.GetDataTable("select name from sysobjects where xtype = 'u' or xtype='v'");
     foreach (DataRow dr in dt.Rows)
     {
         ret.Add(dr["name"].ToString());
     }
     return ret;
 }
Example #2
0
 /// <summary>
 /// ȡ�����ݷ��������������ݿ���
 /// </summary>
 /// <param name="login">��¼��Ϣ</param>
 /// <returns>���ݿ�������</returns>
 public List<string> GetAllDataBases(string connectString)
 {
     List<string> ret = new List<string>();
     Base_DbOperate DbOperate = new Base_DbOperate(connectString);
     if (!DbOperate.Open())
         return null;
     DataTable dt = DbOperate.GetDataTable("select name from Master.dbo.sysdatabases");
     foreach (DataRow dr in dt.Rows)
     {
         ret.Add(dr["name"].ToString());
     }
     return ret;
 }