ASP.NET

private static CultureInfo GetLoggedInUserCulture()
{
    string folderName = string.Empty;
    string sID = GetWindowsLoggedInUserSID();
    object locale = Registry.Users.OpenSubKey(sID + @"\Control Panel\International").GetValue("Locale");
    int lCID = int.Parse(locale.ToString(), NumberStyles.HexNumber);
    CultureInfo ci = new CultureInfo(lCID);
    return ci;
}
private static string GetWindowsLoggedInUserSID()
{
    string userName = null;
    string sID = null;
    try
    {
        ManagementScope oMs = new ManagementScope();
        ObjectQuery oQuery = new ObjectQuery("Select UserName from Win32_ComputerSystem");
        ManagementObjectSearcher oSearcher = new ManagementObjectSearcher(oMs, oQuery);
        ManagementObjectCollection oReturnCollection = oSearcher.Get();
        ManagementClass mc = new ManagementClass(oMs, new ManagementPath("ServerBinding"), null);
        foreach (ManagementObject oReturn in oReturnCollection)
        {
              userName = oReturn["UserName"].ToString().ToLower();
        }

            userName = userName.Substring(userName.LastIndexOf(@"\") + 1);
            oQuery = new ObjectQuery("Select SID, Name from Win32_Account where Name = '" + userName + "'");
            oSearcher = new ManagementObjectSearcher(oMs, oQuery);
            oReturnCollection = oSearcher.Get();

            foreach (ManagementObject oReturn in oReturnCollection)
            {
                if (oReturn["SID"] != null)
                {
                    sID = oReturn["SID"].ToString();
                }
            }
    }
    catch (Exception)
    {
        throw;
    }
    return sID;
}

im very new to asp.net.
i develop a website for e-commerce..now i developing a page to display the statistic of the product that bought by costumer..
here is my database structure..
Table Product-ProductID,ProductName,Description
Table Transaction-TransactionID,User,ProductID,Quantity

-in table Transaction, i store the product that bought by user with user name and quantity.
-table product, store the information about product

-this is my data, assume Bag ProductID=1 and Pencil ProductID=2 in table transaction..
-for table transaction:
TransactionID | User | ProductID | Quantity
1             | ali  | 1         | 2
1             | abu  | 2         | 3
1             | qwe  | 1         | 5

i want make a statistic about the product that bought by users..
im using this Select query= "SELECT Product.ProductName, COUNT(Transaction.ProductID) AS ProductCount FROM Product INNER JOIN Transaction ON Product.ProductID = Transaction.ProductID GROUP BY Product.ProductName"

when using this query the result is,
ProductName | ProductCount
Bag         | 2
Pencil      | 1

i just want my result shown like i stated below..but i dont know how to do it..
ProductName | ProductCount
Bag         | 7
Pencil      | 3

please help me....