Yaar I m trying to retreive the data from XML file i.e Price and Artist but the problem is that I cannot separate the elements selected by the node iterator ,it places both artist and price together in the one column as u c in node iterator code I m selecting both , and the output is as ,

I want only price should be in price column and artist should be in artist column

If any idea how to do ,plz reply



Regards,

Kulbir Sandhu





Price
 Artist

Bob Dylan
 Bob Dylan

10.90
 10.90

Bonnie Tyler
 Bonnie Tyler

9.90
 9.90

Dolly Parton
 Dolly Parton

9.90
 9.90

Gary Moore
 Gary Moore

10.20
 10.20

Eros Ramazzotti
 Eros Ramazzotti

9.90
 9.90










  DataTable dt = new DataTable();

        dt.Columns.Add("Price", typeof(string));

        dt.Columns.Add("Artist", typeof(string));





        XPathDocument doc = new XPathDocument(@"D:\WebSite1\kulbir\XMLXpath\Books. xml");

        XPathNavigator nav = doc.CreateNavigator();

        XPathNodeIterator iter = nav.Select("//catalog/cd/artist | //catalog/cd/price");





        while (iter.MoveNext())

        {

            DataRow dr = dt.NewRow();

            dr["Price"] = iter.Current.Value;

            dr["Artist"] = iter.Current.Value;

            dt.Rows.Add(dr);



        }

        dgr.DataSource = dt;

        dgr.DataBind();







    }

}


kulbir

I'm not sure why you've posted to an XSLT forum and mentioned XSLT in your title when you aren't using XSLT.

I would have thought it was pretty obvious that if you do this:

            dr["Price"] = iter.Current.Value;

            dr["Artist"] = iter.Current.Value;

then both variables will be set to the same value.

Better to do your XPath iteration over the cd elements, and then select the child artist/price elements of each cd by direct navigation.

Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference