problems with data format string

well, i have this .aspx code:

<asp:GridView ID="GridView3" DataSourceID="test" runat="server" AutoGenerateColumns="False">
       <Columns>
               <asp:BoundField DataField="deuda" 
              HeaderText="deuda" ReadOnly="True"
              SortExpression="deuda" DataFormatString="{0:#,##0}" HtmlEncode="False" />
       </Columns>
</asp:GridView>

and its data source has this query:

set @lvl = 0;
set @saldo = 0;
WHILE @saldo < (SELECT (80 * (sum(CASE WHEN a1.c11 <> 0 AND DATEADD(DAY, CONVERT(FLOAT(10), KDUD.C16), A1.C7) < DATEADD(day, - 90, GETDATE())
 THEN ((a1.C17 / a1.C11) * a1.C20) END)) / 100) 
 FROM kdue a1 
 LEFT JOIN KDMM ON KDMM.C1 = 'U' AND A1.C3 = KDMM.C2 AND A1.C4 = KDMM.C3 AND A1.C5 = KDMM.C4 
 LEFT JOIN KDMS ON A1.C1 = KDMS.C1 
 LEFT JOIN KDUD ON A1.C2 = KDUD.C2 
 LEFT JOIN KDUV ON A1.C18 = KDUV.C2
  WHERE a1.c1 = '02-01') 
  BEGIN SET
   @saldo = @saldo + 
   (SELECT 
   sum(CASE WHEN a1.c11 <> 0 AND DATEADD(DAY, CONVERT(FLOAT(10), KDUD.C16), A1.C7) < DATEADD(day, - 90, GETDATE()) THEN ((a1.C17 / a1.C11) * a1.C20) END) AS x
    FROM KDUE A1 
    LEFT JOIN KDMM ON KDMM.C1 = 'U' AND A1.C3 = KDMM.C2 AND A1.C4 = KDMM.C3 AND A1.C5 = KDMM.C4
     LEFT JOIN KDMS ON A1.C1 = KDMS.C1
      LEFT JOIN KDUD ON A1.C2 = KDUD.C2 
      LEFT JOIN KDUV ON A1.C18 = KDUV.C2
       WHERE a1.c1 = '02-01' GROUP BY kdud.c3 ORDER BY x DESC OFFSET @lvl ROWS FETCH NEXT 1 ROWS ONLY);
        SET @lvl = @lvl + 1 END 
        select replace(cliente,' ','')as cliente,replace(convert(varchar,round(p,0)),'.000000000','')as deuda from
(
SELECT TOP (@lvl) kdud.c3 as cliente, 
        (sum(CASE WHEN a1.c11 <> 0 THEN ((a1.C17 / a1.C11) * a1.C20) END)) AS p 
        FROM KDUE A1 
        LEFT JOIN KDMM ON KDMM.C1 = 'U' AND A1.C3 = KDMM.C2 AND A1.C4 = KDMM.C3 AND A1.C5 = KDMM.C4 
        LEFT JOIN KDMS ON A1.C1 = KDMS.C1 LEFT JOIN KDUD ON A1.C2 = KDUD.C2 
        LEFT JOIN KDUV ON A1.C18 = KDUV.C2 
        WHERE a1.c1 = '02-01' AND DATEADD(DAY, CONVERT(FLOAT(10), KDUD.C16), A1.C7) < DATEADD(day, - 90, GETDATE()) 
        GROUP BY kdud.c3 ORDER BY p DESC)as x

which returns 2 columns called deuda and cliente, on my asp.net project on visual basic 2013 i tried to add the query to the data source with the wizard but since it adds parameters and they will mess up my query i added the asp columns manually and tried to apply the data format string but it just ignores it...