How to display data in grid view based on shorting order

See more:

C#

C#4.0

Hi,
I have have written dataset for retrieving data directly from stored procedure .

OUTPUT-- After executing Stored procedure output is coming like this.

3RD PARTY SUPPLIER	422	60	40
CONTRACTOR	        808	43	57
EQUIPMENT SERVICE	260	85	15

I am displaying in fronted in same format as above output in grid view. but in grid view i need to display data this below order-

CONTRACTOR	    808	 43	57
3RD PARTY SUPPLIER  422	 60	40  
EQUIPMENT SERVICE   260	 85	15

This is the SP-----

declare @Total as table (SC_SupplierCategoryName Nvarchar(100),PG_TotalAntExend int,PG_PercMadeinOmanTotal int)
insert into @Total(SC_SupplierCategoryName,PG_TotalAntExend,PG_PercMadeinOmanTotal)
select 'CONTRACTOR', SUM(PG_TotalAntExend)as total1, SUM(PG_TotalAntExend*PG_PercMadeinOman)/SUM(PG_TotalAntExend) as PG_PercMadeinOmanTotal
from TR_ICV_PlanningGoods
where SC_SupplierCategoryID in (1,4) and ICV_ID in(select ICV_ID from TM_ICV where icv_supplier_contractID=@ContractNumber)
group by  SC_SupplierCategoryID
		
	

--declare @Total as table (SC_SupplierCategoryName Nvarchar(100),PG_TotalAntExend int,PG_PercMadeinOmanTotal int)

insert into @Total(SC_SupplierCategoryName,PG_TotalAntExend,PG_PercMadeinOmanTotal)
select '3RD PARTY SUPPLIER', SUM(PG_TotalAntExend)as total1, SUM(PG_TotalAntExend*PG_PercMadeinOman)/SUM(PG_TotalAntExend) as PG_PercMadeinOmanTotal
from TR_ICV_PlanningGoods
where SC_SupplierCategoryID in (2,5) and ICV_ID in(select ICV_ID from TM_ICV where icv_supplier_contractID=@ContractNumber)
group by  SC_SupplierCategoryID




insert into @Total(SC_SupplierCategoryName,PG_TotalAntExend,PG_PercMadeinOmanTotal)
select 'EQUIPMENT SERVICE', SUM(PG_TotalAntExend)as total1, SUM(PG_TotalAntExend*PG_PercMadeinOman)/SUM(PG_TotalAntExend) as PG_PercMadeinOmanTotal
from TR_ICV_PlanningGoods
where SC_SupplierCategoryID in (3) and ICV_ID in(select ICV_ID from TM_ICV where icv_supplier_contractID=@ContractNumber)
group by  SC_SupplierCategoryID

--select * from @Total

select SC_SupplierCategoryName , sum(PG_TotalAntExend) as Total_Expenditure, 
(sum(PG_TotalAntExend*PG_PercMadeinOmanTotal)/sum(PG_TotalAntExend)) as Made_in_Oman, 
100 - (sum(PG_TotalAntExend*PG_PercMadeinOmanTotal)/sum(PG_TotalAntExend)) as Not_Made_In_Oman

from @Total  group by SC_SupplierCategoryName