<% String dsn = ConfigurationSettings.AppSettings["dsn"]; Voloper.DBLayer m_DBLayer = new Voloper.DBLayer(dsn); String strSQL = "sp_top_category_get"; SqlParameter[] myParams = { m_DBLayer.CreateSqlParameter("@language_id", SqlDbType.Int, 4, ParameterDirection.Input, 1) }; String xml = ""+m_DBLayer.RunSQLReturnXML (strSQL, myParams, true); int order_id; if (Request.Cookies["order_id"] != null && Request.Cookies["order_id"].Value != string.Empty) order_id = Convert.ToInt32(Request.Cookies["order_id"].Value); else order_id = 0; strSQL = "sp_shop_cart_xml"; SqlParameter[] myParams2 = { m_DBLayer.CreateSqlParameter("@order_id", SqlDbType.Int, 4, ParameterDirection.Input, order_id) }; xml += m_DBLayer.RunSQLReturnXML (strSQL, myParams2, true); xml += ""; XmlDocument doc = new XmlDocument(); doc.LoadXml (xml); %>

<% if (doc.SelectSingleNode ("/root/shopcart/item") != null) Response.Write (doc.SelectSingleNode ("/root/shopcart/item").InnerText); %> <% if (doc.SelectSingleNode ("/root/symbol") != null) Response.Write (doc.SelectSingleNode ("/root/symbol").InnerText); if (doc.SelectSingleNode ("/root/shopcart/subtotal") != null) Response.Write (doc.SelectSingleNode ("/root/shopcart/subtotal").InnerText); %>

Sign Guestbook Please post a message to be added to the guestbook ... Guest Name   Date 9/9/2010 Time 2:12 AM Title Message