Can we store the data in Excel file in My PC directly

Question

0.00/5 (No votes)

See more:

I have a Stored Procedure

SQL

Create procedure selectdata
as 
begin
    select * from Employee
end

In my front End I Created a Button in default.aspx page

HTML

<asp:Button id="btnsave" runat="server" Text="Send to Excel" onclick="btnsave_Click"/>

<asp:GridView id="gv" runat="server" >
</asp:GridView>

In default.aspx.cs

C#

protected void btnsave_Click(object sender, EventArgs e)
{
    SqlConnection conn = new SqlConnection();
    conn.ConnectionString="User id=aa; password=123; Initial Catalog=abc;Integrated Security=xxxx";
    SqlCommand cmd = new SqlCommand();
    cmd.Connection = conn;
    cmd.CommandText = "selectdata";
    cmd.CommandType = CommandType.StoredProcedure;
    SqlDataAdapter da = new SqlDataAdapter(cmd);
    DataSet ds = new DataSet();
    da.Fill(ds);
    gv.DataSource = ds;
    gv.DataBind();
}

Output: It Displays the Data in Grid View

but is it possible to store the Data directly in Excel file in my PC

Posted 2-Sep-13 21:29pm

Venkat Kumar chigulla

Updated 2-Sep-13 21:37pm

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

v2

Add a Solution

2 solutions

Solution 1

Follow...

1. DataSet to Excel in Two steps – with Different Styles[^]
2. How to export excel from dataset or datatable in c#?[^]

Posted 2-Sep-13 21:39pm

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

Comments

Venkat Kumar chigulla 3-Sep-13 3:53am

i got this Error
The type or namespace name does not exist in the namespace (are you missing an assembly reference?

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 3-Sep-13 4:02am

Which link you referred? The error is quite clear; you are missing some assembly reference.
Add them.

Venkat Kumar chigulla 3-Sep-13 4:06am

I followed the first link DataSet to Excel in Two steps – with Different Styles[^]

I added a reference "Microsoft.Office.Interop.Excel"

Even though i got the Same error

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 3-Sep-13 5:57am

Do you have Excel installed on your machine?

Venkat Kumar chigulla 3-Sep-13 6:04am

Excel 2010 is there in My PC and my Framework is 3.5

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 3-Sep-13 6:15am

Please check the discussion about this type of error on the bottom of Articles.
Errors when compiling your source code in Visual Studio 2010

It might help you.

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Venkat Kumar chigulla · Accepted Answer · 2013-09-04T19:46:00

In Default.aspx

<asp:gridview id="gv" runat="server" >
    
</asp:gridview>
    
    
<asp:button id="btnsend" runat="server" text="Export to Excel" onclick="btnsend_Click"  />

In Default.aspx.cs

protected void Page_Load(object sender, EventArgs e)
    {
        if (IsPostBack != true)
        {
            BindGrid();
            
        }
    }

    private void BindGrid()
    {
        SqlConnection con = new SqlConnection();
        con.ConnectionString = "Data Source=aa; User Id=aa; Password=aa; Initial Catalog=aa; Integrated Security=xxxx";

        SqlCommand cmd = new SqlCommand();
        cmd.Connection = con;

        cmd.CommandText = "select * from student_info";
        cmd.CommandType = CommandType.Text;

        SqlDataAdapter da = new SqlDataAdapter();
        da.SelectCommand = cmd;

        DataTable dt = new DataTable();
        da.Fill(dt);

        gv.DataSource = dt;
        gv.DataBind();
    }

    protected void btnsend_Click(object sender, EventArgs e)
    {
        Response.Clear();
        Response.Buffer = true;
        Response.AddHeader("content-disposition", "attachment;filename=abc.doc");
        Response.ContentType = "application/vnd.ms-word";

        StringWriter sw = new StringWriter();
        HtmlTextWriter hw = new HtmlTextWriter(sw); 
        BindGrid();
        gv.RenderControl(hw);
        Response.Output.Write(sw.ToString()); 
        Response.End();
    }

    public override void VerifyRenderingInServerForm(Control control)
    {
        /* Confirms that an HtmlForm control is rendered for the specified ASP.NET
           server control at run time. */
    }