some problem

[Imran Khan Pathan]

hi friends i have three table one is category with catid and catname second is product with catid,proid and proname third is item with proid,itemid,item name,price,...etc now i want to bind it in below format category name2 product name item name1 price ..... .... .... ... ... item name2 price ..... .... .... ... ... . . category name2 product name2 item name price . . . . . . . i think all of u understand my problem but i cant get any idea which control i have to use. plz give me some idea thanks pathan

[Blue_Boy]

Are you trying to say that "want to combine one query which conatains data of three tables related with them: Categories with Product , Item with Product" something like this: select C.*,P.*,I.* from Categories as C,Products as P, Items as I where P.IDCategory = C.ID and I.IDProduct = P.ID

[Sandeep Akhare]

HI Imran i have ddone this its better to create custom control than using DataGrid or Repeater any thing create a custom control and develop logic you can do any thing with as you are going to write all those controls in render method ?

[Imran Khan Pathan]

No.i have no query problem i have a problem that which control is used to bind in this format pathan

[Imran Khan Pathan]

Thanks for ur reply sandeep i will try to create custom control pathan

[Pradipta Basu]

DataGrid with TemplateColumn will solve your problem. Inside the TemplateColumn use a table to structure the data the way you want. Thanks,

Pradipta Basu