how to export sqldata to microsoft excel

Question

0.00/5 (No votes)

See more:

hi have label as name ,age ,add and corresponding textbox and 2 button as
iinsert and export .i want that when user click insert data wll store in
sql database thats fine .i have done this now what i want is that user click export data should display in microsoft excel sheet. i search the google got some code but not able to do so in my project.plz help

Posted 20-Aug-10 5:53am

software_Engi08

Add a Solution

2 solutions

Solution 1

Excel understands .csv. Many databases allow .csv export. Try it ;)

Posted 20-Aug-10 6:16am

Nyarost

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)

T.Saravanann · Accepted Answer · 2010-08-20T06:29:00

Solution 2

Hi sahuanil,

http://www.codedigest.com/Articles/ASPNET/130_Export_to_Excel_in_ASPNet_20_%E2%80%93Gridview_to_Excel_DataTable_to_Excel.aspx[^]

http://www.codersource.net/asp-net/asp-net-miscellaneous/exporting-data-grid-to-excel-using-c.aspx[^]

These links are useful to you.

Thanks,
T.Saravanan :)

Posted 20-Aug-10 6:29am

T.Saravanann

Comments

software_Engi08 20-Aug-10 14:51pm

hi got the code and i find that it works.but i didnt understand it properly
ie Response.AddHeader("content-disposition", attachment);
what does this code do.wat is "content-disposition".
also wat this code does Response.ContentType = "application/ms-excel";
is it mandatary to write application/ms-excel.