I am developing a clinical laboratory system project, in which i have added category as: Urine Examination , and etc..
then under this category i add more than one sub category,, and under those subcategories i add more than one tests using primary-foreign keys, Now while generating report, when i select Main category from dropdownlist as Urine Examination, I want that the sub categories under this category will be shown in labels and with those labels i want to show the tests which come under the subcategory. how to retrieve this type of data, multiple data without knowing the number of labels used.
Can anybody Suggest something.
i have table in database in which values are stored a
id cat test val
1. micoexpansion albumin 40
2. microexpanison sugar 20
3. microexpansion jhhj 30
4. macroexpnsion glucose 01
5. macroexpansion hjkh 50
when i am displaying this data in gridview
after formatting i get like this
but i want oto show like this
how can i perform this..
Thanks in Advance.
You need categorized microexpansion & macroexpansion in different table like Main Category and give them any unique ID. Now just reference these ID in your sub-categories table.
You have to use two tables-->
then use the query--> select m.M_NAME,s.S_NAME from Main_Category m,Subcategory s where m.M_ID = s.M_ID and M_Name= 'microexpansion or macroexpansion'
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)