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