private void Test_Load(object sender, EventArgs e) { MemberClass member = new MemberClass(); DataTable dt = member.getAllRole(); DataRow drRole = dt.NewRow(); drRole["role_name"] = "กรุณาเลือกสิทธิ์การใช้งาน"; drRole["role_id"] = "0"; dt.Rows.Add(drRole); edit_role_cb.DisplayMember = "role_name"; edit_role_cb.ValueMember = "role_id"; edit_role_cb.DataSource = dt; edit_role_cb.SelectedValue = "0"; }
private void EditUserForm_Load(object sender, EventArgs e) { if (EditUserForm.UserID != "") { MemberClass member = new MemberClass(); DataTable RoleDT = member.getAllRole(); DataRow drRole = RoleDT.NewRow(); drRole["role_name"] = "กรุณาเลือกสิทธิ์การใช้งาน"; drRole["role_id"] = "0"; RoleDT.Rows.Add(drRole); edit_role_cb.DisplayMember = "role_name"; edit_role_cb.ValueMember = "role_id"; edit_role_cb.DataSource = RoleDT; edit_role_cb.SelectedValue = "0"; MemberClass mem = new MemberClass(); DataTable UserDT = mem.getUserLoginByID(EditUserForm.UserID); if (UserDT.Rows.Count > 0) { admin_username_tb.Text = UserDT.Rows[0]["username"].ToString(); edit_role_cb.SelectedValue = UserDT.Rows[0]["role_id"].ToString(); if (UserDT.Rows[0]["account_status"].ToString() == "1") { active_user_rb.Checked = true; } else { disable_user_rb.Checked = true; } } else { MessageBox.Show("ไม่พบ User ID ในระบบ"); } } }