protected void Page_Load(object sender, EventArgs e)
{
dsReportTableAdapters.dtUsersOfAdminTableAdapter dtUsersOfAdminTA = new dsReportTableAdapters.dtUsersOfAdminTableAdapter();
dsReport.dtUsersOfAdminDataTable dtUsersOfAdminDT = new dsReport.dtUsersOfAdminDataTable();
dtUsersOfAdminDT = dtUsersOfAdminTA.GetUsersOfAdmin();
gvUsers.DataSource = dtUsersOfAdminDT;
gvUsers.DataBind();
lblResult.Text = "Number of users: <b>" + dtUsersOfAdminDT.Rows.Count + "</b>";
}
protected void Page_Load(object sender, EventArgs e)
{
dsReportTableAdapters.dtUsersOfAdminTableAdapter dtUsersOfAdminTA = new dsReportTableAdapters.dtUsersOfAdminTableAdapter();
dsReport.dtUsersOfAdminDataTable dtUsersOfAdminDT = new dsReport.dtUsersOfAdminDataTable();
dtUsersOfAdminDT = dtUsersOfAdminTA.GetUsersOfAdmin();
//dsReportTableAdapters.dtUsersByRequestorTableAdapter dtUsersByRequestorTA = new dsReportTableAdapters.dtUsersByRequestorTableAdapter();
//dsReport.dtUsersByRequestorDataTable dtUsersByRequestorDT = new dsReport.dtUsersByRequestorDataTable();
//dtUsersByRequestorDT = dtUsersByRequestorTA.GetUsersByRequestor(Convert.ToInt32(Request.QueryString["id"].ToString()));
//gvUsers.DataSource = dtUsersByRequestorDT;
gvUsers.DataSource = dtUsersOfAdminDT;
gvUsers.DataBind();
//dsCompanyTableAdapters.dtRequestorLastNameTableAdapter dtRequestorLastNameTA = new dsCompanyTableAdapters.dtRequestorLastNameTableAdapter();
//dsCompany.dtRequestorLastNameDataTable dtRequestorLastNameDT = new dsCompany.dtRequestorLastNameDataTable();
//dtRequestorLastNameDT = dtRequestorLastNameTA.GetRequestorLastNameByID(Convert.ToInt32(Request.QueryString["id"].ToString()));
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_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);
gvUsers.RenderControl(htmlWrite);
/*
* sqlDataAdapter1.Fill(dsDownload1, "users");
* if (!Page.IsPostBack)
* {
* dgDownload.DataSource = dsDownload1;
* dgDownload.DataBind();
* }
* dgDownload.RenderControl(htmlWrite);
*/
Response.Write(stringWrite.ToString());
Response.End();
}