Showing posts with label Excel Sheet. Show all posts
Showing posts with label Excel Sheet. Show all posts

Export Gridview to Excel Inside of Ajax UpdatePanel Using in Asp.Net C#

06:55:00  , , , , ,  No comments

Export Grid view to Excel Inside of Ajax 

 Update Panel 


Grid view Data Export to Excel inside of ajax update panel using in asp.net c#.

                                   DEMO

                                               

                             Download
                      
                       HTML CODING
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>Export Gridview to Excel Inside of Ajax UpdatePanel Using in Asp.Net C#</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
      
        <asp:ScriptManager ID="ScriptManager1" runat="server"></asp:ScriptManager>
        <asp:UpdatePanel ID="UpdatePanel1" runat="server" UpdateMode="Conditional"><ContentTemplate>
            <asp:Gridview ID="GridView1" runat="server" AutoGenerateColumns="false">
                <AlternatingRowStyle ForeColor="Gray" />
               <Columns>
                  <asp:BoundField  HeaderText="Employee Name" DataField="Empname"/> <asp:BoundField  DataField="Id" HeaderText="Employee Id"/>
               </Columns>
                <HeaderStyle ForeColor="Blue" />
            </asp:Gridview>

                                                         
            &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
            <asp:Button ID="btnExportExcel" runat="server" OnClick="btnExportExcel_Click" Text="Export to Excel" />

                                                          </ContentTemplate>
            <Triggers>
                <asp:AsyncPostBackTrigger ControlID="GridView1" />
                <asp:PostBackTrigger ControlID="btnExportExcel" />
            </Triggers>
        </asp:UpdatePanel>
    </div>
    </form>
</body>
</html>



                               C# CODING


using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.IO;

public partial class Export_Gridview : System.Web.UI.Page
{
   
    protected void Page_Load(object sender, EventArgs e)
    {
        SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["dbcon"].ToString());
        con.Open();
        if (!IsPostBack)
        {
            SqlDataAdapter adp = new SqlDataAdapter("select * from Employee",con);
            DataSet ds = new DataSet();
            adp.Fill(ds);
            GridView1.DataSource = ds;
            GridView1.DataBind();
        }
    }
    protected void btnExportExcel_Click(object sender, EventArgs e)
    {
        Response.ClearContent();
        Response.AddHeader("content-disposition", "attachment; filename=CustomerDetails.xls");
        Response.ContentType = "application/excel";
        StringWriter SW = new StringWriter();
        HtmlTextWriter HTW = new HtmlTextWriter(SW);
        GridView1.RenderControl(HTW);
        Response.Write(SW.ToString());
        Response.End();

    }
    public override void VerifyRenderingInServerForm(Control control)
    {
        //base.VerifyRenderingInServerForm(control);
    }


}



First - Create New Webform  - Add Ajax Updatepanel inside add gridview  and DataBound



Next - Add Updatepanel - property - Trigger - Gridview1 





 Next - Add Updatepanel - property - Trigger - Add AsyncPostBack = ExcelExportButton - Add  & Update mode = Conditional







  Gridview Same Data Export  to Excel 







Read More

Export Gridview Data To Excel,Pdf,.Csv,Txt,Html,Doc Files Using Dropdownlist Selected Value in Asp.Net C#

07:07:00  , , , , ,  No comments

Export Gridview Data To Excel,Pdf,.Csv,Txt,Html,Doc Files


Export Gridview Data To Excel,Pdf,.Csv,Txt,Html,Doc Files Whenever Select Dropdownlist Value Using asp.Net C#.

                              
                          DEMO


                           Download


    Add Pdf ITextsharp Reference Below Link

http://dotnetdrizzles.blogspot.in/2014/09/how-to-create-pdf-document-in-asp-net.html 

                       HTML Coding

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div >
       

 <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False">
            <AlternatingRowStyle BackColor="Gray" />
            <Columns>
                <asp:BoundField DataField="Id" HeaderText="ID" />
                <asp:BoundField DataField="username" HeaderText="User Name" />
                <asp:BoundField DataField="course" HeaderText="Course" />
            </Columns>
            <HeaderStyle BackColor="#FFCCFF" />
        </asp:GridView>
<table> <tr><td>
      
        <asp:DropDownList ID="DropDownList1" runat="server" Style="font-size: 18px;
                cursor: pointer; background-color:silver; padding: 5px 10px 5px 10px;" Width="124px">

            <asp:ListItem Text="Word File" Value="wordfile"></asp:ListItem>
                <asp:ListItem Text="HTML File"></asp:ListItem>
                <asp:ListItem Text="PDF File" ></asp:ListItem>
                <asp:ListItem Text="Excel File"></asp:ListItem>
                <asp:ListItem Text="Text File"></asp:ListItem>
                <asp:ListItem Text="CSV File" ></asp:ListItem>
        </asp:DropDownList>
            </td></tr>
            <tr><td>
                <br />
                &nbsp;
                <asp:Button ID="Button7" Style="width: 150px; font-size: 18px;
                cursor: pointer; background-color:gray; padding: 5px 10px 5px 10px; margin-left: 0px;" runat="server" OnClick="Button7_Click" Text="Download File" />
                </td></tr>
        </table>

    </div>
    </form>
</body>
</html>
                 
                       C# Coding

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.IO;
using System.Text;
using System.Web.UI.HtmlControls;
using iTextSharp.text;
using iTextSharp.text.pdf;
using iTextSharp.text.html.simpleparser;

public partial class Download : System.Web.UI.Page
{

    SqlConnection con;
    SqlCommand cmd;
    SqlDataAdapter adp;
    SqlDataReader rd;
    DataSet ds;
    string query;
    DataTable dtTable = new DataTable();

    public void dbcon()
    {
        string connn = (System.Configuration.ConfigurationManager.ConnectionStrings["dbcon"].ToString());
        con = new SqlConnection(connn);
        con.Open();

    }
    protected void Page_Load(object sender, EventArgs e)
    {
        gridbind();
    }
    protected void gridbind()
    {
        dbcon();
        query = "select * from Reg";
        cmd = new SqlCommand(query, con);
        adp = new SqlDataAdapter(cmd);
        ds = new DataSet();
        adp.Fill(ds);
        GridView1.DataSource = ds;
        GridView1.DataBind();
    }
   
    protected void txt()
    {
        gridbind();
        string text = string.Empty;

        foreach (TableCell Tblcell in GridView1.HeaderRow.Cells)
        {

            text += Tblcell.Text + "\t\t";
        }


        text += "\r\n";

        foreach (GridViewRow row in GridView1.Rows)
        {
            foreach (TableCell Tblcell in row.Cells)
            {
                text += Tblcell.Text + "\t\t";
            }

            text += "\r\n";
        }

        Response.Clear();
        Response.Buffer = true;
        Response.AddHeader("content-disposition", "attachment;filename=Gridtxt.txt");
        Response.Charset = "";
        Response.ContentType = "application/text";
        Response.Output.Write(text);
        Response.Flush();
        Response.End();
    }
    public override void VerifyRenderingInServerForm(Control control)
    {
        //base.VerifyRenderingInServerForm(control);
    }
  
    protected void csv()
    {
        gridbind();
        Response.Clear();
        Response.Buffer = true;
        Response.AddHeader("content-disposition", "attachment;filename=GridCsv.csv");
        Response.Charset = "";
        Response.ContentType = "application/text";
        GridView1.AllowPaging = false;
        GridView1.DataBind();
        StringBuilder str = new StringBuilder();
        for (int k = 0; k < GridView1.Columns.Count; k++)
        {
            str.Append(GridView1.Columns[k].HeaderText + ',');
        }

        str.Append("\r\n");
        for (int i = 0; i < GridView1.Rows.Count; i++)
        {
            for (int k = 0; k < GridView1.Columns.Count; k++)
            {
                str.Append(GridView1.Rows[i].Cells[k].Text + ',');
            }

            str.Append("\r\n");
        }

        Response.Output.Write(str.ToString());
        Response.Flush();
        Response.End();
    }
    protected void doc()
    {
        gridbind();
        Response.Clear();
        Response.Buffer = true;
        Response.AddHeader("content-disposition",
        "attachment;filename=GridDoc.doc");
        Response.Charset = "";
        Response.ContentType = "application/vnd.ms-word ";
        StringWriter sw = new StringWriter();
        HtmlTextWriter hw = new HtmlTextWriter(sw);
        GridView1.AllowPaging = false;
        GridView1.DataBind();
        GridView1.RenderControl(hw);
        Response.Output.Write(sw.ToString());
        Response.Flush();
        Response.End();
    }
    protected void html()
    {
        HtmlForm form = new HtmlForm();
        GridView1.AllowPaging = false;
        gridbind();
        Response.ClearContent();
        Response.AddHeader("content-disposition", "attachment; filename=GridHtml.html");
        Response.Charset = "";
        Response.ContentType = "text/html";
        StringWriter sw = new StringWriter();
        HtmlTextWriter htw = new HtmlTextWriter(sw);
        form.Attributes["runat"] = "server";
        form.Controls.Add(GridView1);
        this.Controls.Add(form);
        Form.RenderControl(htw);
        Response.Write(sw.ToString());
        Response.Flush();
        Response.End(); 
    }
    protected void pdf()
    {
        gridbind();
        Response.ContentType = "application/pdf";
        Response.AddHeader("content-disposition", "attachment;filename=GridPdf.pdf");
        Response.Cache.SetCacheability(HttpCacheability.NoCache);
        StringWriter sw = new StringWriter();
        HtmlTextWriter hw = new HtmlTextWriter(sw);
        GridView1.AllowPaging = false;
        GridView1.DataBind();
        GridView1.RenderControl(hw);
        GridView1.HeaderRow.Style.Add("width", "15%");
        GridView1.HeaderRow.Style.Add("font-size", "10px");
        GridView1.Style.Add("text-decoration", "none");
        GridView1.Style.Add("font-family", "Arial, Helvetica, sans-serif;");
        GridView1.Style.Add("font-size", "8px");
        StringReader sr = new StringReader(sw.ToString());
        Document pdfDoc = new Document(PageSize.A2, 7f, 7f, 7f, 0f);
        HTMLWorker htmlparser = new HTMLWorker(pdfDoc);
        PdfWriter.GetInstance(pdfDoc, Response.OutputStream);
        pdfDoc.Open();
        htmlparser.Parse(sr);
        pdfDoc.Close();
        Response.Write(pdfDoc);
        Response.End();
    }
    protected void excel()
    {
        Response.ClearContent();
        Response.AddHeader("content-disposition", "attachment; filename=GridExcel.xls");
        Response.ContentType = "application/excel";
        System.IO.StringWriter sw = new System.IO.StringWriter();
        HtmlTextWriter htw = new HtmlTextWriter(sw);
        GridView1.RenderControl(htw);
        Response.Write(sw.ToString());
        Response.End();
    }
   
    private void Download_File(string FilePath)
    {
        Response.ContentType = ContentType;
        Response.AppendHeader("Content-Disposition", "attachment; filename=" + Path.GetFileName(FilePath));
        Response.WriteFile(FilePath);
        Response.End();
    }
    protected void Button7_Click(object sender, EventArgs e)
    {
        string strFileType;
        strFileType = DropDownList1.Text.ToString();
        switch (strFileType)
        {
            case "HTML File":
                html();
                break;
            case "Word File":
                doc();
                break;
            case "Text File":
                txt();
                break;
            case "Excel File":
                excel();
                break;
            case "PDF File":
                pdf();
                break;           
            case "CSV File":
                csv();
                break;
           
        }
    }
    }



Add New Webform - Select Gridview,Dropdownlist,Button From toolbox




Next - Add Namespaces - Bind GridView & Download All Formate Coding




Next - Add To Swith the Case Selected Dropdownlist Items



Read More