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 }