about data paging in C/S application

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

cnSoftware - 14 Mar 2004 14:55 GMT

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?

Reply to this Message

William Ryan eMVP - 14 Mar 2004 19:04 GMT

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

> 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?

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...