What is The Effective Way....

[Mohamad Al Husseiny]

I want to return a larg set of records from database server to the client tier -win forms- so the question 1-what is the effective way to do this? 2- is it differ if they connected via Wan or via the Internet thanks in advace

[Marek Grzenkowicz]

Two very basic advices: 1. return ONLY the data that you really need (do not use SELECT * ...), 2. return all data using ONE batch to minimize the network traffic; don't do something like:

do
  [your query]
while (...)

modified on Monday, August 30, 2010 6:42 AM

[Mohamad Al Husseiny]

thanks chopeen for your reply of course i will return the data that i realy need so the question at the case that i really need many records when you work with disconected data you may have situation like this you want to create dataset which have many records or if you implement your business objects so the question again ho to do this effectively thanks again i need your advices gurus

[Guillermo Rivero]

You can use a DataSet object. It works perfect on disconected enviroments. Also look information on the DataAdapter object. The DataAdapter, will translate the modifications done to your DataSet to the DataBase. :) Free your mind...

[Mohamad Al Husseiny]

Thanks Guillermo Rivero it seems that i did not explain what i need exactly i know that i can use dataset on disconected enviroments but Is it will work fine if the returned records = 1000000 ? for example. in situation i need this data

[Guillermo Rivero]

Well, I once did load a DataSet with 2 million records and it worked fine. Each record had 5 fields. ;) Free your mind...

[Mohamad Al Husseiny]

Thanks Guillermo Rivero for your help thats ok for me but i want to ask you another question do you know good resources (books - web sites...) about Designing distrebuted application in .net that have real world examples? i have some books about remoting and webservice but they are teaching technology with out real world examples . thanks in advance

[Guillermo Rivero]

Ok, I read somewhenre in msdn.microsoft.com[^] something about Application Blocks. And I'm almost sure that there is Distributed Application Block. There you can have guidelines on how to design Distributed Applications. The other way is design, your own. I prefer the second one... ;) Free your mind...

[Mohamad Al Husseiny]

thanks again Guillermo Rivero i really appreciate your interact with my quetsion i will post two qestion about paging May you take a look about them?

[jscorales]

To: Mohamad Al Husseiny Hi there. Have you got a solution to your problem already? Because im encountering that same problem. if you already have the solution please it would help me a lot thanks.:)