Xml query giving the error when the dhtml grid is loaded

Discontinued products Uncategorized discussions
#1

string strPlaceCode = string.Empty;

string strXMLPlace = HttpContext.Current.Server.MapPath("~/XML/Monuments.xml");

string strNavNamePlace = “data”;

XQueryNavigatorCollection navcolPlaces = new XQueryNavigatorCollection();

XmlDocument xDocPlace = new XmlDocument();

xDocPlace.Load(strXMLPlace);

navcolPlaces.AddNavigator(xDocPlace.CreateNavigator(), strNavNamePlace);

string strXQuery = “{FOR $searchPlace in document(‘data’)/data/entrances where $searchPlace/placeName=’” + pstrPlaceName.Trim() + “’ RETURN $searchPlace/placeId }”;



XQueryExpression xexpr = new XQueryExpression(strXQuery);

string resultXML = xexpr.Execute(navcolPlaces).ToXml();

DataSet ds = new DataSet();

ds.ReadXml(new StringReader(resultXML));





Error Is ::::----



‘(’ expected. Maybe you are using a known function name like last, data, text etc as an identifier. For this release , this is not allowed.





:::::—



my xml Format is









1

391

Agra

<no_of_pax>1</no_of_pax>

<monument_name>Taj Mahal</monument_name>

<rates_in>BOTH (USD/INR)</rates_in>

<closed_on>Friday</closed_on>

<usd_entrance>15</usd_entrance>

<inr_entrance>20</inr_entrance>

Rates for foriener details = 15$ for adult and 10$ for child. Night view allowed between 2030 to 0030hrs. maximam 8 batch of 50 pax allowed for the evening duration 30 minute.

sunrise to 19:00hrs

<updated_by>amarjeet</updated_by>

<updated_at>2005-03-25</updated_at>





















#2

The problem is not related to component.

>>Maybe you are using a known function name like last, data,
>><data>
>>