DataSet ISdeVersionInfo.GetAllVersionsAsDataset(out List<string> versions, int is_express)
{
string sql = "select * from sde.sde.SDE_versions";
//List<string> _versions = new List<string>();
versions = new List<string>();
DataSet ds = new DataSet();
IDataManager dataManager = new DataManager();
if (is_express == SQLServerVersion.IS_EXPRESS)
{
try
{
ds = dataManager.TnQueryBySQL(SQLServerVersion.IS_EXPRESS, null, sql);
}
catch { }
}
else if (is_express == SQLServerVersion.NON_EXPRESS)
{
try
{
ds = dataManager.TnQueryBySQL(SQLServerVersion.NON_EXPRESS, null, sql);
}
catch { }
}
foreach (DataRow row in ds.Tables[0].Rows)
{
versions.Add("sde." + row[0].ToString());
}
return ds;
}
List<string> ISdeVersionInfo.GetAllVersions()
{
string sql = "select name from sde.sde.SDE_versions";
List<string> versions = new List<string>();
DataSet ds = new DataSet();
IDataManager dataManager = new DataManager();
try
{
ds = dataManager.TnQueryBySQL(SQLServerVersion.IS_EXPRESS, null, sql);
}
catch
{
ds = dataManager.TnQueryBySQL(SQLServerVersion.NON_EXPRESS, null, sql);
}
finally
{
foreach (DataRow row in ds.Tables[0].Rows)
{
versions.Add("sde." + row[0].ToString());
}
}
return versions;
}
