protected void ButtonXuat_Click(object sender, EventArgs e) { Response.ClearContent(); Response.AppendHeader("content-disposition", "attachment; filename=Khach_Hang.doc"); Response.ContentType = "application/word"; StringWriter stringWriter = new StringWriter(); HtmlTextWriter htw = new HtmlTextWriter(stringWriter); GridViewKhachHang.RenderControl(htw); Response.Write(stringWriter.ToString()); Response.End(); }
protected void Page_Load(object sender, EventArgs e) { if (System.Web.HttpContext.Current.Session["ten"] == null) { Response.Redirect("DangNhap.aspx"); } String sql = "Select * from KhachHang"; table = DungChung.XemQuery(sql); GridViewKhachHang.DataSource = table; GridViewKhachHang.DataBind(); String doublequote = "\"'',''\""; String sqlincome = @"SELECT Sum(HoaDon.TongSoTien) AS SumOfTongSoTien, Format([NgayDi],'mm" + doublequote + @"yyyy') AS thoigian FROM DatPhong INNER JOIN HoaDon ON DatPhong.ID = HoaDon.IDDatPhong GROUP BY Format([NgayDi],'mm" + doublequote + @"yyyy');"; DataTable tableincome = DungChung.XemQuery(sqlincome); Chart1.DataSource = tableincome; Chart1.DataBind(); }
protected void GridViewKhachHang_PageIndexChanging(object sender, GridViewPageEventArgs e) { GridViewKhachHang.PageIndex = e.NewPageIndex; GridViewKhachHang.DataSource = table; GridViewKhachHang.DataBind(); }