Click here to Skip to main content
15,889,659 members
Home / Discussions / .NET (Core and Framework)
   

.NET (Core and Framework)

 
QuestionNeed help with the event based async pattern Pin
Jeroen De Dauw10-Dec-09 4:55
Jeroen De Dauw10-Dec-09 4:55 
AnswerRe: Need help with the event based async pattern Pin
Ashfield11-Dec-09 1:21
Ashfield11-Dec-09 1:21 
GeneralRe: Need help with the event based async pattern Pin
Jeroen De Dauw11-Dec-09 3:25
Jeroen De Dauw11-Dec-09 3:25 
GeneralRe: Need help with the event based async pattern Pin
Ashfield11-Dec-09 9:29
Ashfield11-Dec-09 9:29 
QuestionExport to excel [modified] Pin
Uma J10-Dec-09 0:16
Uma J10-Dec-09 0:16 
AnswerRe: Export to excel Pin
dan!sh 10-Dec-09 1:18
professional dan!sh 10-Dec-09 1:18 
AnswerRe: Export to excel Pin
Ashfield10-Dec-09 1:24
Ashfield10-Dec-09 1:24 
AnswerRe: Export to excel Pin
Dave Kreskowiak10-Dec-09 4:26
mveDave Kreskowiak10-Dec-09 4:26 
You may want to do a little test first to see how much of your data you can actually fit in a WORKBOOK, not a worksheet.

Yeah, you're going to exceed the number of rows available in a single sheet, and that's handled with a bit of work on your part. But, you're bigger problem is that you're probably going to run Excel out of memory before you get through all of your customers.

The test is easy. Take a small sample of records from your database and export them to an Excel sheet. Then copy and paste those records over and over again filling up the sheet as much as possible. Then create a new sheet and paste the records into that, filling up the sheet as much as possible. I think you'll find that you run Excel out of memory fairly quickly and long before you get through all of your customers.


A guide to posting questions on CodeProject[^]



Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
     2006, 2007, 2008
But no longer in 2009...




AnswerRe: Export to excel Pin
The Man from U.N.C.L.E.11-Dec-09 22:57
The Man from U.N.C.L.E.11-Dec-09 22:57 
QuestionPOP3 Class Pin
joelle@scope9-Dec-09 2:17
joelle@scope9-Dec-09 2:17 
AnswerRe: POP3 Class Pin
Richard MacCutchan9-Dec-09 3:26
mveRichard MacCutchan9-Dec-09 3:26 
QuestionType inference problem [modified/solved] Pin
Gideon Engelberth8-Dec-09 13:50
Gideon Engelberth8-Dec-09 13:50 
Questionhow to use .net framework with c++; Pin
geniuspc8-Dec-09 12:04
geniuspc8-Dec-09 12:04 
AnswerRe: how to use .net framework with c++; Pin
DaveyM698-Dec-09 12:34
professionalDaveyM698-Dec-09 12:34 
AnswerRe: how to use .net framework with c++; Pin
Paul Conrad8-Dec-09 13:28
professionalPaul Conrad8-Dec-09 13:28 
AnswerRe: how to use .net framework with c++; Pin
The Man from U.N.C.L.E.9-Dec-09 7:10
The Man from U.N.C.L.E.9-Dec-09 7:10 
Questionhow to insert image Pin
darkyro8-Dec-09 4:03
darkyro8-Dec-09 4:03 
AnswerRe: how to insert image Pin
Luc Pattyn8-Dec-09 5:10
sitebuilderLuc Pattyn8-Dec-09 5:10 
QuestionDifference between events in c# and vb.net Pin
ddecoy8-Dec-09 1:39
ddecoy8-Dec-09 1:39 
AnswerRe: Difference between events in c# and vb.net Pin
Dave Kreskowiak8-Dec-09 5:22
mveDave Kreskowiak8-Dec-09 5:22 
AnswerRe: Difference between events in c# and vb.net Pin
The Man from U.N.C.L.E.8-Dec-09 8:17
The Man from U.N.C.L.E.8-Dec-09 8:17 
GeneralRe: Difference between events in c# and vb.net Pin
ddecoy9-Dec-09 2:42
ddecoy9-Dec-09 2:42 
GeneralRe: Difference between events in c# and vb.net Pin
The Man from U.N.C.L.E.9-Dec-09 7:07
The Man from U.N.C.L.E.9-Dec-09 7:07 
QuestionHow to upload a xml file on Rest web server Pin
~Khatri Mitesh~7-Dec-09 1:22
~Khatri Mitesh~7-Dec-09 1:22 
AnswerRe: How to upload a xml file on Rest web server Pin
Rama Krishna Vavilala7-Dec-09 6:29
Rama Krishna Vavilala7-Dec-09 6:29 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.