protected void Page_Load(object sender, EventArgs e)
        {
            if (!ReadNodeId())
                Response.Redirect("Error.aspx");

            string vxkConnection = ConfigurationHelper.ReadString("VXK.Connection");
            TimeSpan vxkTimeout = ConfigurationHelper.ReadTimeSpan("VXK.Timeout");

            VXStorageConnection conn = new VXSqlStorageConnection();
            conn.Parse(vxkConnection);
            VXKManager vxk = new VXKSqlManager(conn);
            vxk.CommandTimeout = vxkTimeout;

            DataMap map = new DataMap();
            map.Load(vxk, m_nodeId);

            m_renderedItems = map.BuildRenderedItems();
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            string vxkConnection = "data source=db-vxk.svc.cnprod.cnwk; initial catalog=vxk; user id=vxkuser; password=#vxkuser#;";
            TimeSpan vxkTimeout = TimeSpan.Parse("00:01:00");

            VXStorageConnection conn = new VXSqlStorageConnection();
            conn.Parse(vxkConnection);
            VXKManager vxk = new VXKSqlManager(conn);
            vxk.CommandTimeout = vxkTimeout;

            using (SqlConnection conn1 = new SqlConnection(@"Data Source=RUFRW-OSHU\SQL2005; Initial Catalog=Work; Integrated Security=SSPI;"))
            {
                conn1.Open();

                using (SqlCommand cmd = conn1.CreateCommand())
                {
                    cmd.CommandText = "SELECT * FROM [Result] ORDER BY [ItemUid], [ParentTree]";

                    Guid lastItemUid = Guid.Empty;
                    using (SqlDataReader reader = cmd.ExecuteReader())
                    {
                        while (reader.Read())
                        {
                            Guid itemUid = (Guid)reader["ItemUid"];
                            if (itemUid != lastItemUid)
                            {
                                VXInfoItem item = KB.Template.Multipleimages.ReadItem(vxk, (VXGuid)itemUid);
                                RenderedItem render = new RenderedItem();
                                render.InfoItem = item;
                                string html = render.Render();
                                html = html.Replace("50px;", "200px;");
                                html = html.Replace("37px;", "150px;");
                                Response.Write(html + Environment.NewLine);

                                lastItemUid = itemUid;
                            }

                            bool original = (bool)reader["Original"];
                            int skuId = (int)reader["SkuId"];
                            string pn = (string)reader["Pn"];

                            string parentTree = (string)reader["ParentTree"];
                            parentTree = parentTree.Replace("%%%", @"\");

                            string stdDesc = (string)reader["StandardDescription"];

                            string part = String.Format(
                                "<table class=\"Item {0}\"><tr><td><div class=\"Content2 Fourfold\"><div class=\"Mark {0}\">{1}</div><div class=\"Title\"><b>SKU ID: {2}</b><br />{4}<br /></div></div></td><td><div class=\"Content2 Fourfold\"><div class=\"Text\">{5}</div></div></td></tr></table>",
                                original ? "Mkt" : "Attribute",
                                original ? "BOX" : "LICENSE",
                                skuId,
                                pn,
                                parentTree,
                                stdDesc);

                            Response.Write(part + Environment.NewLine);
                        }
                    }
                }
            }
        }