Asp.net how to display fetched data
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