Click here to Skip to main content
15,914,416 members
Home / Discussions / C#
   

C#

 
QuestionSqlDataAdapter.Fill Pin
CodingYoshi7-Jan-09 8:37
CodingYoshi7-Jan-09 8:37 
AnswerRe: SqlDataAdapter.Fill Pin
Wendelius7-Jan-09 8:45
mentorWendelius7-Jan-09 8:45 
GeneralRe: SqlDataAdapter.Fill Pin
CodingYoshi7-Jan-09 9:51
CodingYoshi7-Jan-09 9:51 
GeneralRe: SqlDataAdapter.Fill Pin
Wendelius7-Jan-09 10:06
mentorWendelius7-Jan-09 10:06 
GeneralRe: SqlDataAdapter.Fill Pin
CodingYoshi7-Jan-09 10:22
CodingYoshi7-Jan-09 10:22 
GeneralRe: SqlDataAdapter.Fill Pin
Wendelius7-Jan-09 10:29
mentorWendelius7-Jan-09 10:29 
GeneralRe: SqlDataAdapter.Fill Pin
Dave Kreskowiak7-Jan-09 10:46
mveDave Kreskowiak7-Jan-09 10:46 
GeneralRe: SqlDataAdapter.Fill Pin
Rutvik Dave7-Jan-09 10:15
professionalRutvik Dave7-Jan-09 10:15 
because your console application is just displaying the data using (I think) data reader, right ?

if thats the case then,

Reader is a forward only cursor so it will just fetch the chunk of rows and then sends them for display and forget it, until all the rows are displayed.

while the SqlDataAdapter will actually hold the complete result in the memory. so it will take some time also if you have less RAM then hdd paging will take even more time. so try to divide the rows, so that your Dataset dont have to hold the whole table. (i.e. some section wise or category wise)
AnswerRe: SqlDataAdapter.Fill Pin
Le centriste8-Jan-09 3:37
Le centriste8-Jan-09 3:37 
QuestionC# launches another program Pin
ipstefan7-Jan-09 8:29
ipstefan7-Jan-09 8:29 
AnswerRe: C# launches another program Pin
Dave Kreskowiak7-Jan-09 10:08
mveDave Kreskowiak7-Jan-09 10:08 
AnswerRe: C# launches another program Pin
Dragonfly_Lee7-Jan-09 19:53
Dragonfly_Lee7-Jan-09 19:53 
AnswerRe: C# launches another program Pin
Pritam Karmakar7-Jan-09 21:45
Pritam Karmakar7-Jan-09 21:45 
GeneralRe: C# launches another program Pin
ipstefan8-Jan-09 0:12
ipstefan8-Jan-09 0:12 
AnswerRe: C# launches another program Pin
HosamAly8-Jan-09 0:09
HosamAly8-Jan-09 0:09 
GeneralRe: C# launches another program Pin
ipstefan8-Jan-09 0:15
ipstefan8-Jan-09 0:15 
GeneralRe: C# launches another program Pin
HosamAly8-Jan-09 5:38
HosamAly8-Jan-09 5:38 
QuestionForcina a space or suppressing zeroes in Data Grid Pin
Vanq20097-Jan-09 7:53
Vanq20097-Jan-09 7:53 
AnswerRe: Forcina a space or suppressing zeroes in Data Grid Pin
Henry Minute7-Jan-09 9:08
Henry Minute7-Jan-09 9:08 
QuestionRe: Forcina a space or suppressing zeroes in Data Grid Pin
Vanq20097-Jan-09 10:38
Vanq20097-Jan-09 10:38 
AnswerRe: Forcina a space or suppressing zeroes in Data Grid Pin
Henry Minute7-Jan-09 11:02
Henry Minute7-Jan-09 11:02 
GeneralRe: Forcina a space or suppressing zeroes in Data Grid Pin
Vanq20098-Jan-09 2:02
Vanq20098-Jan-09 2:02 
QuestionFileSystemWatcher Events Fired Twice Pin
#realJSOP7-Jan-09 5:58
professional#realJSOP7-Jan-09 5:58 
AnswerRe: FileSystemWatcher Events Fired Twice Pin
Dave Kreskowiak7-Jan-09 6:15
mveDave Kreskowiak7-Jan-09 6:15 
GeneralRe: FileSystemWatcher Events Fired Twice Pin
#realJSOP7-Jan-09 6:43
professional#realJSOP7-Jan-09 6:43 

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.