I have for example SQL statement:

SELECT categoryID,categoryName FROM categories

I can get products like this:

Select productId,productName from products where categoryId=@catID

If I bind this to dataGrid I want to have beside the categoryName also links
to products in this category.

Category name is link to edit category name , where you can change it.
Product names are also links to edit the product name, where you can change
it.

One row should look like this:

CATEGORYID CATEGORYNAME PRODUCTNAME

   1   Computers IBM computer
   Dell computer
   Compaq

I have 2 books and I didn't find any information how to do that.
Can someone help me? Is there any example

Thank you,
Simon