private void LoadDatabases()
{
try
{
if (txtServer.Text.Trim().Length > 0)
{
Cursor.Current = Cursors.WaitCursor;
cboDatabase.Items.Clear();
GenericSQLServerDAL dal = new GenericSQLServerDAL();
dal.Server = txtServer.Text;
dal.Database = "master";
if (!chkIntegratedSec.Checked)
{
dal.UserName = txtUserName.Text;
dal.Password = txtPassword.Text;
}
dal.SetConnection();
DataSet tables = dal.GetDataSet("select name as DatabaseName From sysdatabases where dbid > 4 order by name", CommandType.Text);
if (tables.Tables.Count > 0 && tables.Tables[0].Rows.Count > 0)
{
foreach (DataRow r in tables.Tables[0].Rows)
{
cboDatabase.Items.Add(r[0].ToString());
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Loading databases", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
Cursor.Current = Cursors.Default;
}
public long GetDBSize()
{
long sizeMB = 0;
GenericSQLServerDAL sqlDal = new GenericSQLServerDAL()
{
Server = SqlServer, Database = "master"
};
if (!IntegratedSecurity)
{
sqlDal.UserName = UserName;
sqlDal.Password = Password;
}
sqlDal.SetConnection();
DataSet ds = sqlDal.GetDataSet(Properties.Resources.SelectDatabaseSizeScript.Replace("<Database>", Database), CommandType.Text);
if (ds != null && ds.Tables.Count == 1 && ds.Tables[0].Rows.Count > 0)
{
object tmp = ds.Tables[0].Rows[0]["Size"];
if (tmp != null)
{
sizeMB = long.Parse(tmp.ToString());
}
else
{
throw new Exception("Invalid data returned");
}
}
else
{
throw new Exception("No or invalid database specified!");
}
return(sizeMB);
}
