Stapeldiagram.

Jag försöker att med hjälp av asp.net 2.0 och C# bygga lite statistik.
Tabell:
Listan
ID
Namn
Svar1 - Svar10
Ratt
Fel
NyTid
Datum

Fråga frDatum

SELECT Listan.ID, Listan.Datum, Year([Datum]) AS År, Month([Datum]) AS 
Månad, Day([Datum]) AS Dag
FROM Listan;
//Kodbehind
private void antalRatt()
    {
        lTitel.Text = "Statistik för: " + DatumUtil.monthName
(DateTime.Now.Month) + " " + DateTime.Now.Year;

        string sql1 = "SELECT  count(Ratt) AS antal, Ratt AS vilkenRatt from 
Listan  group by Ratt ORDER BY Ratt DESC";
        DataSet ds1 = new DataSet();
        OleDbDataAdapter Adapter1 = new OleDbDataAdapter();
        Adapter1.SelectCommand = new OleDbCommand(sql1, DBConn);
        Adapter1.Fill(ds1, "t_countRight1");

        string sql2 = "SELECT *  FROM frDatum ";
        DataSet ds2 = new DataSet();
        OleDbDataAdapter Adapter2 = new OleDbDataAdapter();
        Adapter2.SelectCommand = new OleDbCommand(sql2, DBConn);
        Adapter2.Fill(ds2, "t_countRight2");

        string sql3 = "select (sum(ratt)+0.0)/count(*) AS antaltotal from 
listan";
        DataSet ds3 = new DataSet();
        OleDbDataAdapter Adapter3 = new OleDbDataAdapter();
        Adapter3.SelectCommand = new OleDbCommand(sql3, DBConn);
        Adapter3.Fill(ds3, "t_countRight3");

        string visaResult = "<table border=1 Width=250px rules=none>" +
            "<tr><td colspan='5' class='Titel'>Procentvis antal rätt!</td></tr>" +
            "<tr Class='Dark'><td colspan='2' class='smallTitel'>Rätt</td><td colspan='3' class='smallTitel'>Antal rätt</td></tr>";

        string stapelBild = "";
        int k = 1;
        string myStyle="";
        int TotalCount = 0;
        decimal Count2 = Convert.ToDecimal(ds3.Tables["t_countRight3"].Rows
[0]["antaltotal"]);
        //decimal highCount = 0;
        for (int i = 0; i < 11; i++)
        {
            if(k==1)
            {
                myStyle="Light";
            }
            else
            {
                myStyle="Dark";
                k=0;
            }
             TotalCount =  Convert.ToInt32(ds2.Tables["t_countRight2"].Rows.Count);
            decimal Count1 = (Convert.ToDecimal(ds1.Tables["t_countRight1"].Rows[i]["antal"]) / TotalCount) * 100;
            int antalRatt = Convert.ToInt32(ds1.Tables["t_countRight1"].Rows[i]
["antal"]);

            
             int ratt = Convert.ToInt32(ds1.Tables["t_countRight1"].Rows[i]
["vilkenRatt"]);
            
            stapelBild = "../Bild/Stapel/" + i + ".gif";

            visaResult += "<tr class= " +myStyle+"><td Width=50px 
align=right> " + ratt.ToString() + "</td>";
            visaResult += "<td Width='100px'> <img src=" + stapelBild + " 
border=1 height=10 width=" + 4 * Count1 + "></td>";
            visaResult += "<td Width='30px' align =right> " + antalRatt + "</td>";
            visaResult += "<td Width='20px'>: </td><td align=right 
width='100px'>" + Math.Round(Count1, 2) + " %</td>";
            k+=1;
        }
         visaResult += "<tr><td  colspan=4>Antal tävlande :</td><td 
align='right'> <b>" + TotalCount +"</b></td>";
        visaResult += "<tr><td  colspan=4>Genomsnitsligt antal rätt :</td><td 
align='right'><b>" + Math.Round(Count2, 2) + "</b></td>";
        visaResult += "</tr></table>";
        lAntalRatt.Text = visaResult;
    }

Det känns som om jag jobbar helt galet, koden fungerar, men hur bör jag
ändra den?