SqlDataSource Foreach Query

I'm using a sql data source and I need to perform a foreach query. I have a collection of id's and I need to hit my database (the one available via sql data source) for each of the id's in the collection. I know that the sql data source returns a data view and it can be coverted to a data table. What's the best way to query a database using the sql data source ojbect for each id in a collection? Here's my code.

<code>

private void GetJobsFromPSI(JobQueueCollection jobs)

{

// Create a data view.

DataView dv = new DataView();

// Get the id's.

JobQueueCollection jobs = GetJobsFromQueue(Membership.GetUser().ProviderUserKey());

// Now that we have all of the user id's we

// need to call out the jobs from PSI.

foreach (JobQueue job in jobs)

{

// Get query for each id in the job collection.

// Somehow add a new datarowview to the data view for each

// query.

}

}

</code>