private void Subjects_Load(object sender, EventArgs e) { //homeworks //... object[,] result = _db.ScanRecords("tbl_subject", "Subject_ID", "Subject_Name"); for (int i = 0; i < result.GetLength(0); i++) { Random r = new Random(); Color c = Color.FromArgb(r.Next(75, 125), r.Next(75, 125), 175); Usercontrols.PictureButton pb = new Usercontrols.PictureButton() { Tag = result[i, 0], Title = result[i, 1].ToString(), Count = r.Next(5), BackColor = c, ForeColor = Color.White }; pb.Click += Pb_Click; flpGallery.Controls.Add(pb); } flpGallery.VerticalScroll.Maximum += 135; }
private void Subjects_Load(object sender, EventArgs e) { //homeworks //... object[,] result = _db.ScanRecords( @"tbl_studentinfo INNER JOIN tbl_classlist ON tbl_classlist.Student_no = tbl_studentinfo._id INNER JOIN tbl_sectionlist ON tbl_classlist.Section_id = tbl_sectionlist.Section_id INNER JOIN tbl_subjectinfo ON tbl_sectionlist.Subject_id = tbl_subjectinfo._id", new string[] { "Subject" }, "tbl_studentinfo._id = '" + _account.UserId + '\'' ); for (int i = 0; i < result.GetLength(0); i++) { Random r = new Random(); Color c = Color.FromArgb(r.Next(75, 125), r.Next(75, 125), 175); Usercontrols.PictureButton pb = new Usercontrols.PictureButton() { Title = result[i, 0].ToString(), Count = r.Next(5), BackColor = c, ForeColor = Color.White }; pb.Click += Pb_Click; flpGallery.Controls.Add(pb); } flpGallery.VerticalScroll.Maximum += 135; }