Question Query's help

[Danerd100]

Hi,
Okay, here's my setup. I have designed my entire database. In the database, I have products, and categories, so I made a view to view the info about one product and it's category with it.

I am going to make it so buttons are added via code (Dynamic) based on how many products are in lets say category 1. How would I go about finding out how many products (rows) whose category field = Category 1? (The category is a field on my products table)

If you need further explanation, let me know

 

[cjard]

Why dont you use a button column for a datagridview, then the DGV will take over the rendering of all the buttons:

Column Types in the Windows Forms DataGridView Control