Convert SQL Server 2005 table into Excel format using ASP.NET with C#

[sachin]

Hi everyone...
can anyone help me in finding a solution to this problem? I have to
fetch some data from SQL Server 2005 and export it as Excel file.

[Greg]

So what is the start of your probelm?

Do you need help connecting to a SQl Server Datatbase?

Do you need help creating an excel spreadsheet?

I am new here, but I have founf that you really will learn a lot and
get faster replies here if you give examples of your work rather than
just asking others to do the work for you.

For instance if you said , I don't know how to get information from a
SAL Server database using C# then someone would probably tell you to
go to this link...

http://www.codeproject.com/KB/database/sql_in_csharp.aspx

that link would probably solve the first half of your program.

Then you could ask, how do I create an Excel Spreasdsheet using Excel
and someone would probably give you this link...

http://msdn.microsoft.com/en-us/library/ms173186(VS.80).aspx

Now you have the second half of your program..

I have found that this group is excellent at providing help with the
actual coding after you show them you are trying.

And they are excellent at explaining what you are doing wrong (and
right) and assisiting you (without solving it for you).


I hope this helped you, I know they have been a great help to me!

[David L. Crooks]

I have used Excelxmlwriter and it is free.

David L. Crooks

[Pit Ufo]

Any code?

[David L. Crooks]

If you go to the website there is small sample and google
Excelxmlwriter for many examples available.

David L. Crooks