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