<div>
<div class="content wysiwyg-content">
<br />
Hi All,<br />
<br />
I would truly appreciate help on the following matter:<br />
<br />
I have two Datasets (each a result of a different database select):<br />
<br />
1. Jobs: int jobid (primary key), string jobname, string jobtype.<br />
2. UserJobs: userid, jobid (N-To-N relation).<br />
<br />
I would like to create a dataset that will contain all the jobs of a certain user. For example, I want have a dataset with all the jobs of a user with userid=5.<br />
<br />
How can I do that efficiently? (I have got about 100,000 records in the UserJobs table - for about 1000 users).<br />
<br />
Thanks!<br />
<br />
Agmon,<br />
<br />

</div>
</div>



Hi All,

I would truly appreciate help on the following matter:

I have two Datasets (each a result of a different database select):

1. Jobs: int jobid (primary key), string jobname, string jobtype.
2. UserJobs: userid, jobid (N-To-N relation).

I would like to create a dataset that will contain all the jobs of a certain user. For example, I want have a dataset with all the jobs of a user with userid=5.

How can I do that efficiently? (I have got about 100,000 records in the UserJobs table - for about 1000 users).

Thanks!

Agmon,



Datasets join

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).