void Load_data()
{
using (var conn = SQL.GetConnection()) {
SqlCommand sqlCmd = new SqlCommand("SELECT Diem.MaSv,HoTen,MaMon,DiemTP,DiemThi,DiemTongKet,NgayCapNhat FROM Diem, SinhVien WHERE SinhVien.MaSv=Diem.MaSv", conn);
DataSet dt = new DataSet();
SqlDataAdapter sqlAdap = new SqlDataAdapter(sqlCmd);
sqlAdap.Fill(dt);
DSDiem.DataSource = dt;
DSDiem.DataBind();
conn.Close();
}
}
protected void ExportToExcel(object sender, EventArgs e)
{
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment;filename=RepeaterExport.xls");
Response.Charset = "";
Response.ContentType = "application/vnd.ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
DSDiem.RenderControl(hw);
Response.Output.Write(sw.ToString());
Response.Flush();
Response.End();
// dt = city.GetAllCity();//your datatable
}
