I Currently have a stored procedure in ms sql server 2008 which is call from a C# page and returns data into a gridview.
The procedure is named: GetPricesForProduct
and accepts 1 param which is pid this is the product id
so my currect page would call the proc like productdetail.aspx?pid=16612
this would return columns into a gridview
site Blogcategory Productname price
and repeat the data for all rows.