about data paging in C/S application

[cnSoftware]

I have read the article about data paging in msdn. But when I come
across the Master/Detail tables, I find it will be another problem.

If I want to select 100 records into the master table in a dataset,
how can I select just all the records associating with those in master
table from the detail table?

 

[William Ryan eMVP]

cnSoftware:

Let me make sure I understand the problem. You want to select 100 records
from the master table, then you only want the records from the child table
that correspond to it?

Assuming your first select statement was something like Select Top 100 ...
From sometable.

Then you could use Select * from ChildTable where RelatedField In (Select
Top 100 FieldName from SomeTable) should work for you.

HTH,

Bill