Click here to Skip to main content
15,887,683 members
Home / Discussions / C#
   

C#

 
AnswerRe: Shared Methods? Pin
Judah Gabriel Himango9-Feb-06 5:18
sponsorJudah Gabriel Himango9-Feb-06 5:18 
GeneralRe: Shared Methods? Pin
Guffa9-Feb-06 5:56
Guffa9-Feb-06 5:56 
QuestionConvert file extension to mime type Pin
Uwe Keim9-Feb-06 3:48
sitebuilderUwe Keim9-Feb-06 3:48 
QuestionC# TreeView Pin
2dS9-Feb-06 3:45
2dS9-Feb-06 3:45 
AnswerRe: C# TreeView Pin
Andy Moore9-Feb-06 5:28
Andy Moore9-Feb-06 5:28 
GeneralRe: C# TreeView Pin
2dS9-Feb-06 20:09
2dS9-Feb-06 20:09 
QuestionHow to open large database? Pin
Pius__X9-Feb-06 3:10
Pius__X9-Feb-06 3:10 
AnswerRe: How to open large database? Pin
Colin Angus Mackay9-Feb-06 3:26
Colin Angus Mackay9-Feb-06 3:26 
Using a data set means that the results of the query are loaded in their entirity into the dataset first before you can do anything with it. This can take a long time (as you've seen) and take a lot of memory.

There isn't an easy solution for this.

Could you consider using a DataReader instead and processing the data one row at a time? Do you need all 10,000 row in the dataset? Could it just be that the query is very complex and the database needs the time in order to find the relevant rows?

ColinMackay.net
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius
"If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell

AnswerRe: How to open large database? Pin
Le centriste9-Feb-06 4:20
Le centriste9-Feb-06 4:20 
AnswerRe: How to open large database? Pin
emran8349-Feb-06 10:26
emran8349-Feb-06 10:26 
QuestionWizard; Hiding a WizardStep Pin
ZeedijkMike9-Feb-06 3:00
ZeedijkMike9-Feb-06 3:00 
Questionabout axwebbrowser Pin
smr859-Feb-06 2:40
smr859-Feb-06 2:40 
Questiontext box & GO button Pin
Kola Sokol9-Feb-06 1:43
Kola Sokol9-Feb-06 1:43 
AnswerRe: text box & GO button Pin
Judah Gabriel Himango9-Feb-06 5:27
sponsorJudah Gabriel Himango9-Feb-06 5:27 
GeneralRe: text box & GO button Pin
Kola Sokol9-Feb-06 7:36
Kola Sokol9-Feb-06 7:36 
GeneralRe: text box & GO button Pin
Kola Sokol9-Feb-06 8:08
Kola Sokol9-Feb-06 8:08 
QuestionReflection -VectorClass :System.IO.FileNotFoundException Pin
sasire189-Feb-06 1:34
sasire189-Feb-06 1:34 
Question!= Operator Cant be applied Error Pin
emran8349-Feb-06 1:01
emran8349-Feb-06 1:01 
AnswerRe: != Operator Cant be applied Error Pin
Le centriste9-Feb-06 1:38
Le centriste9-Feb-06 1:38 
GeneralRe: != Operator Cant be applied Error Pin
emran8349-Feb-06 2:05
emran8349-Feb-06 2:05 
GeneralRe: != Operator Cant be applied Error Pin
Le centriste9-Feb-06 2:08
Le centriste9-Feb-06 2:08 
QuestionResource files Pin
AB77719-Feb-06 0:55
AB77719-Feb-06 0:55 
AnswerRe: Resource files Pin
emran8349-Feb-06 1:10
emran8349-Feb-06 1:10 
GeneralRe: Resource files Pin
AB77719-Feb-06 1:25
AB77719-Feb-06 1:25 
GeneralRe: Resource files Pin
emran8349-Feb-06 2:00
emran8349-Feb-06 2:00 

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.