private void wqd_stuList_Load(object sender, EventArgs e) { BindCmbKSMC(); DataTable dtStudents = examModel.GetList(combSql()).Tables[0]; dgvList.DataSource = dtStudents; TitleDgvBillList(); }
private void txtStuName_TextChanged(object sender, EventArgs e) { if (checkTxt()) { DataTable dt = new db_students().GetList(" stuName='" + txtStuName.Text.Trim() + "' and idcard='" + txtIdCard.Text.Trim() + "' and examNameID='" + publicModel.examName + "'").Tables[0]; if (dt.Rows.Count > 0) { lblExamNo.Text = dt.Rows[0]["stuno"].ToString(); } else { lblExamNo.Text = "--"; } DataTable dtExam = examModel.GetList(" name like'" + txtStuName.Text.Trim() + "%' and idcard like'" + txtIdCard.Text.Trim() + "%' and examNameID='" + publicModel.examName + "'").Tables[0]; dgvList.DataSource = dtExam; TitleDgvBillList(); } }