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