Huge data

[Sahil Malik]

I just said about the same thing Gregory .. paging is the answer !! ..
Also not using datasets is another possibility. As Jon Skeet said .. 'tis a
tall order. !!

- Sahil Malik
You can reach me thru my blog at
http://www.dotnetjunkies.com/weblog/sahilmalik

 

[Cor Ligthert]

Sahil,

Because of the information you have sand I agree from my first message with
what George is writting.

That was why I was asking then how do you display the data?

However you did not reply that, so I did not sent my basic ideas about this.

I seldom advise the datareader, however you show in my idea something where
it is exactly made for (when you make a good program around it to display
it).

Just my thought based on the current information you showed.

Cor

 

[Sahil Malik]

Cor maybe I didn't quite understand what you are saying. But anyway, how
you'd display the data is not a big deal since the classes you'd write would
all implement the standard interfaces like IList IDisposable etc. so they
could be treated like any standard ADO.NET object like a dataset .. and yes
you could then databind them even .. .. so essentially the same techniques
that you'd use to display the data using a dataset could be used on these
classes.

You might also want to look at datasetsurrogate on the microsoft
knowledgebase, and see how they serialize the dataset, essentially you need
to import the same serialization mechanism and pass it to a custom class
that pages it for you. (Thats the whole idea really).

I'd be happy to write the code as a sample but basically I'm a lazy bum and
this is too much work LOL !!. Anyway, if everyone insists that we absolutely
must have a code sample for this, I'd be happy to write one up and put it on
gotdotnet (just don't expect it tommorow ..). Lemme know !!

- Sahil Malik
You can reach me thru my blog http://www.dotnetjunkies.com/weblog/sahilmalik

 

[Cor Ligthert]

Sahil,

I have seen some questions in this newsgroup of paging a database using a
dataset for a kind of sequential use. I never saw a clear sample how to do
that here, only persons who where telling to do that using the dataview or
select with an extra column, that is a kind of way what you are doing.

Therefore I do not believe in using a dataset for your problem as long as I
have not seen how to do that.

Cor

 

[Sahil Malik]

Cor,

Therefore I do not believe in using a dataset for your problem as long as
I have not seen how to do that.

Uhh .. reverse psychology .. must resist .. uhhh !!! Ahh anyway .. Can you
send me a message with your email address thru my blog? I'll code up a
sample and send it to you. I've done it so I am certain it's do-able.

- Sahil Malik
You can reach me thru my blog http://www.dotnetjunkies.com/weblog/sahilmalik

 

[Cor Ligthert]

Sahil,

My email adres is an almost real email adres, just my lastname the @ and
the provider.

Cor

 

[Cablito]

nows thats being scared shittless of getting spam;

 

[Sahil Malik]

Hey Cor,

I'll try and send you the sample this weekend. A few things came up
(Unexpected work, but who am I to say no to pictures of dead presidents);
but I'll try and get that in.

- Sahil Malik
You can reach me thru my blog at
http://www.dotnetjunkies.com/weblog/sahilmalik