Forms Data Controls :: Add Categories To Repeater That Displays List Of Job Postings

I have a repeater that displays a list of job openings. I now need to modify the repeater and break out the job openings by category.

See below for the existing code for my repeater. I'm not sure how I need to modify my repeater to display the jobs under the appropriate categories.

I've added a new JobsCategory table to the database and added the foreign key relationship between my jobListing table and the jobcategory table.

I've created a new stored procedure to pull the jobs my category:

CREATE PROCEDURE [dbo].[GetJobsByCategory]
@categoryId int
AS
BEGIN
SET NOCOUNT ON
SELECT j.JobID, j.JobTitle, j.URL, j.City, j.State, j.Country, c.CategoryName
FROM ADPJobListing j
INNER JOIN ADPJobCategory c ON j.CategoryID = c.CategoryID
WHERE j.CategoryID = @categoryId
END

In my typed dataset (tableadapter), I'll add a new query to the above stored procedure and finally in my business logic layer, I'll add a new method to call down into my data access layer:

[DataObjectMethod(DataObjectMethodType.Select, false)]
public ADP.JobsDataTable GetJobsByCategory(int categoryId)
{
return this.Adapter.GetJobsByCategory(categoryId);
}

How do I need to modify my repeater to display the jobs by category?

[Code]....