datset problem

[hlybbi]

I have a shop categories, and within these categories, I have subcategories,I want to display just 3 subcategories for each main category

I am using dataset with Relations

ds.Relations.Add("MenuRelation", ds.Tables["Shop_catagory"].Columns["catID"], ds.Tables["Products"].Columns["catagory"]);

can anybody help me i am lost i have tryed to use the sql command SELECT top 3 FROM products but then i only get 3 products into the dataset and not 3 products in that catagory

Best regards Hlynur

http://www.xodus.net

 

[checkai]

you should select top 3 products where categoryid = @cid...what is all the data for? drop down lists?

dlc

 

[hlybbi]

no i am trying to get an tree view in a DataList but only with max 3 subcatagorys in each catagory

Best regards Hlynur

http://www.xodus.net