Example #1
0
    protected void btnExportExcel_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=AidMemoire " + DateTime.Now + ".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 stringWriter = 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 htw = new HtmlTextWriter(stringWriter);

        // Set white color as the background color for gridview header row
        GrdAidMemoire.HeaderRow.Style.Add("background-color", "#FFFFFF");

        // Hide Particular Header and Cell of gridview
        foreach (GridViewRow row in GrdAidMemoire.Rows)
        {
            GrdAidMemoire.HeaderRow.Cells[5].Visible = false;
            row.Cells[5].Visible = false;
        }
        // Set background color of each cell of GridView1 header row
        foreach (TableCell tableCell in GrdAidMemoire.HeaderRow.Cells)
        {
            tableCell.Style["background-color"] = "#2873F0";
        }

        // Set background color of each cell of each data row of GridView1
        foreach (GridViewRow gridViewRow in GrdAidMemoire.Rows)
        {
            gridViewRow.BackColor = System.Drawing.Color.White;
            foreach (TableCell gridViewRowTableCell in gridViewRow.Cells)
            {
                gridViewRowTableCell.Style["background-color"] = "#FFFFFF";
            }
        }

        GrdAidMemoire.RenderControl(htw);
        Response.Write(stringWriter.ToString());
        Response.End();
    }
Example #2
0
 public void GetAidMemoireDetails()
 {
     try
     {
         obj = new AcknowledgementBL();
         DataTable dt = obj.GetAidMemoireBL(Session["UserId"].ToString(), "AidMemoireParentData", "");
         if (dt.Rows.Count > 0)
         {
             GrdAidMemoire.DataSource = dt;
             GrdAidMemoire.DataBind();
         }
         else
         {
             GrdAidMemoire.DataSource = dt;
             GrdAidMemoire.DataBind();
         }
     }
     catch (Exception ex)
     {
         LogError(ex);
     }
 }