protected void Page_Load(object sender, EventArgs e) { //dsReportTableAdapters.dtCompaniesByRequestorTableAdapter dtCompaniesByRequestorTA = new dsReportTableAdapters.dtCompaniesByRequestorTableAdapter(); dsReportTableAdapters.dtCompaniesOfAdminTableAdapter dtCompaniesOfAdminTA = new dsReportTableAdapters.dtCompaniesOfAdminTableAdapter(); //dsReport.dtCompaniesByRequestorDataTable dtCompaniesByRequestorDT = new dsReport.dtCompaniesByRequestorDataTable(); dsReport.dtCompaniesOfAdminDataTable dtCompaniesOfAdminDT = new dsReport.dtCompaniesOfAdminDataTable(); //dtCompaniesByRequestorDT = dtCompaniesByRequestorTA.GetCompaniesByRequestor(Convert.ToInt32(ddlRequestor.SelectedValue)); dtCompaniesOfAdminDT = dtCompaniesOfAdminTA.GetCompaniesOfAdmin(); gvCompany.DataSource = dtCompaniesOfAdminDT; gvCompany.DataBind(); lblResult.Text = "Number of companies: <b>" + dtCompaniesOfAdminDT.Rows.Count + "</b>"; lblBreadCrumb.Text = "<a href=\"./\">Home</a> :: <a href=\"CompanyReport.aspx\">Company Report</a> :: Site Administrator"; }
protected void Page_Load(object sender, EventArgs e) { dsReportTableAdapters.dtCompaniesOfAdminTableAdapter dtCompaniesOfAdminTA = new dsReportTableAdapters.dtCompaniesOfAdminTableAdapter(); dsReport.dtCompaniesOfAdminDataTable dtCompaniesOfAdminDT = new dsReport.dtCompaniesOfAdminDataTable(); dtCompaniesOfAdminDT = dtCompaniesOfAdminTA.GetCompaniesOfAdmin(); gvCompany.DataSource = dtCompaniesOfAdminDT; gvCompany.DataBind(); Response.Clear(); Response.ClearHeaders(); //For HTTPS Response.Cache.SetCacheability(HttpCacheability.Private); //For HTTPS //Response.AddHeader("content-disposition", "attachment; filename=SpifeAssociates"+Convert.ToDateTime(AssociatesDT.Rows[0]["downloaddate"].ToString()).ToShortDateString()+".xls"); Response.AddHeader("content-disposition", "attachment; filename=admin_company_list.xls"); Response.Charset = ""; //Response.Cache.SetCacheability(HttpCacheability.NoCache); // //Response.AddHeader("Content-Type", "application/vnd.ms-excel"); Response.ContentType = "application/vnd.xls"; System.IO.StringWriter stringWrite = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite); gvCompany.RenderControl(htmlWrite); /* * sqlDataAdapter1.Fill(dsDownload1, "users"); * if (!Page.IsPostBack) * { * dgDownload.DataSource = dsDownload1; * dgDownload.DataBind(); * } * dgDownload.RenderControl(htmlWrite); */ Response.Write(stringWrite.ToString()); Response.End(); }