hie
m using visual studio 2005 and sql 2005
i want to export my sql database to excel..
babbu
-12
Posting Whiz in Training
Recommended Answers
Jump to PostThat is not enough information. You can use the import/export wizard built in the SQL Server Management studio. Excel has a limit ~65535 if i recall correctly (may be more in the newer version) so you might not be able to export all of your data. Also do you want …
Jump to Posttry the following code:
/*********************for exporting data to the excel sheet***************/ /************************************************* ************************/ protected void btnCreateExcel_Click(object sender, EventArgs e) { try { ExportGridDataToExcel(gvDataExcel, "EmpInfo"); //empinfo is the excel file name that i want to create } catch (Exception ex) { Response.Write(ex.Message); } finally { Response.End(); } } …
All 8 Replies
sknake
1,622
Senior Poster
Featured Poster
babbu
-12
Posting Whiz in Training
MeSampath
4
Junior Poster
babbu
-12
Posting Whiz in Training
vinnijain
0
Junior Poster
vinnijain
0
Junior Poster
zunkan
0
Newbie Poster
Cameronsmith63
9
Light Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.