private void setDataGridview(string exName) { string query = string.Format("select * from questions join exams on ex_id= q_fk_ex " + exName); using (DataTable table = new DataTable()) { ReturnClass.FillAdapter(query, table); GridView.DataSource = table; } }
private void setDataTable() { string query = "select q_id,ex_id,isImage,q_title,exam_name,ad_add,q_addeddate,explain from questions join exams on questions.q_fk_ex = exams.ex_id"; DataTable dt = new DataTable(); ReturnClass.FillAdapter(query, dt); GridView.DataSource = dt; SetHeader(); }
private void setDataSource() { string query = "select exam_name from exams"; DataTable dt = new DataTable(); ReturnClass.FillAdapter(query, dt); GridView.DataSource = dt; GridView.Columns[0].Width = GridView.Width; GridView.Columns[0].HeaderText = "Tên Môn Học"; }
public static DataTable GetDataSource(string query) { try { DataTable dt = new DataTable(); ReturnClass.FillAdapter(query, dt); return(dt); }catch { return(null); } }
private void AddUsers_Load(object sender, EventArgs e) { Clear(); string query = string.Format("select * from admin_athu where isAd = 0 or ad_user ='******' order by isAd asc", FormLogin.username); using (DataTable dt = new DataTable()) { ReturnClass.FillAdapter(query, dt); viewUser.DataSource = dt; } SetDataTable(); }
private void setDataSource() { string query = "select * from exams"; DataTable dt = new DataTable(); ReturnClass.FillAdapter(query, dt); viewExams.DataSource = dt; viewExams.Columns["ex_id"].Visible = false; viewExams.Columns["exam_name"].Width = viewExams.Width; viewExams.Columns["exam_name"].HeaderText = "Tên Môn Học"; }