protected void img_ExportToExcel6_Click(object sender, ImageClickEventArgs e)
{
if (txt_CodeOstad.Text == string.Empty)
{
txt_CodeOstad.Text = "0";
}
dtResault = FRB.TeachingExperienceMoreThanADay(ddl_Term.SelectedValue, int.Parse(txt_CodeOstad.Text), int.Parse(ddl_Daneshkade.SelectedValue), int.Parse(ddl_Departman.SelectedValue), int.Parse(ddl_Cooperation.SelectedValue), int.Parse(txt_ListSavabeghRuz.Text));
if (dtResault.Rows.Count == 0)
{
}
else
{
GridView6.DataSource = dtResault;
GridView6.DataBind();
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment;filename=ReportTeachingExperienceMoreThanADay.xls");
Response.Charset = "";
Response.ContentType = "application/vnd.ms-excel";
using (StringWriter sw = new StringWriter())
{
HtmlTextWriter hw = new HtmlTextWriter(sw);
//To Export all pages
////gv_Show.AllowPaging = false;
////this.BindGrid();
//gv_Show.HeaderRow.BackColor = Color.White;
foreach (TableCell cell in GridView6.HeaderRow.Cells)
{
cell.BackColor = GridView6.HeaderStyle.BackColor;
}
foreach (GridViewRow row in GridView6.Rows)
{
//row.BackColor = Color.White;
foreach (TableCell cell in row.Cells)
{
if (row.RowIndex % 2 == 0)
{
cell.BackColor = GridView6.AlternatingRowStyle.BackColor;
}
else
{
cell.BackColor = GridView6.RowStyle.BackColor;
}
cell.CssClass = "textmode";
}
}
GridView6.RenderControl(hw);
//style to format numbers to string
string style = @"<style> .textmode { } </style>";
Response.Write(style);
Response.Output.Write(sw.ToString());
Response.Flush();
Response.End();
}
}
}
protected void btnDownloadExcelDQIAfterBVNReport_Click(object sender, EventArgs e)
{
hidTAB.Value = "#tab3";
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment;filename=DQIAfterBVNReportExport.xls");
Response.Charset = "";
Response.ContentType = "application/vnd.ms-excel";
using (StringWriter sw = new StringWriter())
{
HtmlTextWriter hw = new HtmlTextWriter(sw);
//To Export all pages
GridView6.AllowPaging = false;
DQIAfterBVNPageDataBind();//.BindGrid();
GridView5.HeaderRow.BackColor = Color.White;
foreach (TableCell cell in GridView6.HeaderRow.Cells)
{
cell.BackColor = GridView6.HeaderStyle.BackColor;
}
foreach (GridViewRow row in GridView6.Rows)
{
row.BackColor = Color.White;
foreach (TableCell cell in row.Cells)
{
if (row.RowIndex % 2 == 0)
{
cell.BackColor = GridView6.AlternatingRowStyle.BackColor;
}
else
{
cell.BackColor = GridView6.RowStyle.BackColor;
}
cell.CssClass = "textmode";
}
}
GridView6.RenderControl(hw);
//style to format numbers to string
string style = @"<style> .textmode { } </style>";
Response.Write(style);
Response.Output.Write(sw.ToString());
Response.Flush();
Response.End();
}
}
protected void btn5_Click(object sender, EventArgs e)
{
// Clear all content output from the buffer stream
Response.ClearContent();
// Specify the default file name using "content-disposition" RESPONSE header
Response.AppendHeader("content-disposition", "attachment; filename=fees.xls");
// Set excel as the HTTP MIME type
Response.ContentType = "application/excel";
// Create an instance of stringWriter for writing information to a string
System.IO.StringWriter stringWriter5 = new System.IO.StringWriter();
// Create an instance of HtmlTextWriter class for writing markup
// characters and text to an ASP.NET server control output stream
HtmlTextWriter htw5 = new HtmlTextWriter(stringWriter5);
GridView6.RenderControl(htw5);
Response.Write(stringWriter5.ToString());
Response.End();
}