Export Import Data In Excel File Use OF c#
-
Montag, 25. Februar 2013 12:23
Hi Every One i have a lot of data minimum(5 Lacks )in sql server, i want to export this data in a excel sheet quickly through c#.
any body have a smart solution.
Thank you.
- Bearbeitet Amersh Singh Montag, 25. Februar 2013 12:24 mis type
Alle Antworten
-
Montag, 25. Februar 2013 14:58Moderator
Does this help?
http://randomconsultant.blogspot.com/2009/01/export-sql-server-tables-to-excel-in-c.html
looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941
- Als Antwort markiert Amersh Singh Mittwoch, 27. Februar 2013 05:41
-
Dienstag, 26. Februar 2013 13:41
Thanks for help..
But this code much slower. i already use this code.
-
Dienstag, 26. Februar 2013 13:53ModeratorThe best way to do it is to use SSIS. It is not c# but it should work faster.
looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941
.png)
.png)
