private void LoadDatabaseNames()
{
pMain.Controls.Clear();
AddStaticControls();
try
{
using (DataStuff sn = new DataStuff())
{
sn.ConnectionString = ConnectionString;
DataTable dt = sn.GetSystemUserDatabases(ConnectionString);
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
if (Convert.ToInt32(row["database_id"].ToString()) > 4)
{
//User database
CheckBox c = new CheckBox();
c.Parent = pMain;
c.Name = "c" + row["Name"].ToString();
c.Text = row["Name"].ToString();
c.Tag = "User " + row["Name"].ToString();
c.Left = LastX;
c.Top = LastY;
c.Width = 200;
LastY = c.Top + c.Height;
c.CheckedChanged += CheckBox_Clicked;
AllCount++;
}
}
LastY = LastY + 10;
lSystemDB.Top = LastY;
cAllSystemDatabases.Top = lSystemDB.Top + lSystemDB.Height + 5;
LastY = cAllSystemDatabases.Top + cAllSystemDatabases.Height + 5;
foreach (DataRow row in dt.Rows)
{
if (Convert.ToInt32(row["database_id"].ToString()) <= 4)
{
//System database
CheckBox c = new CheckBox();
c.Parent = pMain;
c.Name = "c" + row["Name"].ToString();
c.Text = row["Name"].ToString();
c.Tag = "System " + row["Name"].ToString();
c.Left = LastX;
c.Top = LastY;
c.Width = 200;
LastY = c.Top + c.Height;
c.CheckedChanged += CheckBox_Clicked;
AllCount++;
}
}
}
}
}
catch
{
throw;
}
}
