private void StudentHome_Load(object sender, EventArgs e)
{
metroLabelUser.Text = Login.u; //logged in user name
StudentTransactions st = new StudentTransactions();
s = st.getStudentId(metroLabelUser.Text); // get user id
stdId = s.getid();
//execute methods onload
loadCombo();
loadComboShowMods();
loadComboTab();
}
void loadComboTab()
{
StudentTransactions std = new StudentTransactions();
std.getStudentId(metroLabelUser.Text);
String stid = s.getid();
DataRow dr;
CommonDBTransaction c = new CommonDBTransaction();
string sql = "SELECT mid FROM StudentModule WHERE sid = '" + stid + "'";
DataTable dt = c.searchData(sql);
if (dt.Rows.Count > 0)
{
dr = dt.NewRow();
dr.ItemArray = new object[] { "--Select Module--" };
dt.Rows.InsertAt(dr, 0);
metroComboBoxModl.ValueMember = "mid";
metroComboBoxModl.DisplayMember = "mid";
metroComboBoxModl.DataSource = dt;
}
}