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; } }