Amruta Kirdat

Amruta Kirdat

  • NA
  • 103
  • 34.2k

Asp.net how to display fetched data

Sep 28 2011 12:00 AM
Hii,


I hve two tables named DrugGroup n DrugDetails, they contain folloiwng data 

DrugGroup        DrugDetails
Id        name        DId        Id(FK)        Details
1  Tablets        1        1        ABC
2        Capsules        2        1        ABCD
    3 2        AXY
    4        2        PQE

Now on search btn click i need to search details from DrugDetails table and also display their Name from DrugGroup

o/p should be such as: if user searched for 'a' and den click search btn den my webform should display

Tablets 
1 ABC
2 ABCD

Capsules
1 AXY

i have already feteched data by using join query and used DataRepeater to display data currently my o/p is looking like this

Tablets  ABC
Tablets        ABCD
Capsules        AXY



can any one help me to display proper o/p as i mentioned....


thx
Amruta 


Answers (3)