Dear frinds:
After working with DataAdapter & DataSet I got its a client-side DataSet! And I didnt find any property for Server side & ...
Is it fixed to Client-Side?! How can I change it! I need Server side DataSet!
Thanks in advance.

Always:),
Hovik Melkomian.

__________________
Always,
Hovik Melkomian.

Hi Hovik,

What do you mean with a client side / server side dataset? Are you referring to the "cursor type" from classic ADO?

A DataSet is a disconnected object (that is, it does not need an open connection to the datasource to function), so AFAIK, it's always a "client side" object.

What do you need a server side dataset for? A DataReader might be suitable for that. Can you elaborate a bit what you need?

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: Megalomania by Muse (Track 15 from the album: Hullabaloo) What's This?

Imar: tnx for ur reply.
Imagin I have a table with 100,000 records. as u know if I wanna fill my DataSet it takes too much [u](bc it a Cleint side, [u]refering to classic ADO</u>)</u>.
Its my problem! can u help me, what to do?!

Always:),
Hovik Melkomian.

Hi Hovik,

With such a large table, getting all the data in a DataSet is indeed not a wise decision. With a Server Side cursor in classic ADO, you could still connect to the table, and only retrieve the records you actually needed.

I think the disconnected .NET world asks for a different approach. With such a large table, you are probably better of using a stored procedure that only retrieves the number of records you want to display on your page (I assume you're using paging to present the data. Dumping 100,000 records on a page isn't going to be much fun).

I suggest you read the following articles about "custom paging". The last one is aimed at classic ASP, but the principle with the stored procedures applies to .NET as well.

http://www.dotnetjunkies.com/Tutoria...BDB9B8845.dcik
http://www.4guysfromrolla.com/webtech/062899-1.shtml

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: New York City Cops by The Strokes (From the album: Is This It) What's This?

Ok Imar tnx for response.
I know how to work that way. But I wonder is it the only way?!
Tnx in advance.

Always:),
Hovik Melkomian.

Hmmm, I think so. I think it's an either/or situation. Either you retrieve all the records, or you don't.

If you don't retrieve all the records, you'll need a mechanism that is able to retrieve just the subset you actually need. I can only think of stored procedures to do that, but I might be overlooking something.

The DataReader is the closest to a Server Side cursor, as it works over a live and connected connection. I am not sure, but maybe the Read() method doesn't actually retrieve the records as long as you don't use one of its Get* methods. But still, I think looping 99,990 times to get just the last 10 record is not going to be really fast.

Why do you need a different solution? Can't you use Stored Procedures in your project?

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: Montego Bay Spleen by St Germain (Track 2 from the album: Tourist) What's This?

Sure I can! I just wonted to ask for better way.
Ok im going with that!

Always:),
Hovik Melkomian.