Click here to Skip to main content
15,917,575 members
Please Sign up or sign in to vote.
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

Excel understands .csv. Many databases allow .csv export. Try it ;)
 
Share this answer
 
 
Share this answer
 
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.

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900