HI i havind table like stindent,zpindent,Tpindent table
in this tables COunt(drugs),SUM(qty),SUM(fundamt) group by finyear
same like other tables bt columns name difference
i want to display this three table data in one gridview like this formate ST table,Zp Table ,Tp Table
|
Sl. No. |
Fin Year |
Sector |
|
|
No. of Drugs |
Qty. of Drugs |
Indent Amount |
Action |
|
1 |
2019-20 |
ST |
|
|
|
|
|
view |
|
2 |
2019-20 |
ZP |
|
|
|
|
|
view |
|
3 |
2019-20 |
TP |
|
|
|
|
|
view |
|
4 |
2018-19 |
SS |
|
|
|
|
|
view |