DataTable

public DataTable GetDataShopProductCategories()
        {

            StringBuilder strSql = new StringBuilder();
            strSql.Append("select  CategoryID,CategoryName,ParentCategoryID,ParentCategoryName,ProductTypeFlag,CreatedTime,UpdatedTime,OrderFlag,ChildCount,LeafFlag from XM_Shop_ProductCategories ");

            return SqlUtils.SqlUtilsInstance.TextExecuteDataset(strSql.ToString()).Tables[0];
        }

 

 public string GetShopProductCategoriesAccessoryString()
    {
        StringBuilder builder = new StringBuilder();
        DataTable data = ShopData.Instance.GetDataShopProductCategories();
        DataRow[] rowsParent = data.Select(string.Format("ProductTypeFlag=1 and ParentCategoryID=0"));
        //int count = rowsParent.Length > 4 ? 4 : rowsParent.Length;
        for (int i = 0; i < rowsParent.Length; i++)
        {
            builder.Append("<li>  \r\n");
            builder.Append(string.Format("    <strong class=\"classify\">{0}</strong>  \r\n", rowsParent[i]["CategoryName"].ToString()));
            DataRow[] rows = data.Select(string.Format("ParentCategoryID={0}", rowsParent[i]["CategoryID"].ToString()));
            if (rows.Length > 0)
            {
                builder.Append(string.Format("<a href=\"/accessory/list.aspx?cid={0}\">{1}</a>", rows[0]["CategoryID"].ToString(), rows[0]["CategoryName"].ToString()));
                if (rows.Length > 1)
                {
                    for (int j = 1; j < rows.Length; j++)
                    {
                        builder.Append(string.Format("<span class=\"spe\">|</span><a href=\"/accessory/list.aspx?cid={0}\">{1}</a>", rows[j]["CategoryID"].ToString(), rows[j]["CategoryName"].ToString()));
                    }
                }
            }

            builder.Append("</li>  \r\n");
           
        }


        return builder.ToString();
    }