I have some code for listing product names and corresponding categories, by using Data Sets :
created the Connection, Data Adapter, and Data Set
Filling the Data Set with the Categories table
Changed the command text and retrieve the Products table
Defining the relationship between Categories...