hi,

I am retriving data in hierarchy form in XML by using FOR XML PATH it returns the XML data in a variable in c#. Now I want to read the conmtent of the variable to get node and their name and Id to display it on some control.  But unable to do that ..... Is it possible by using XMLREADER or XMLdocument ....If yes send me some link  or code if not the is it possible to make xml file from the content of the variable .........plz send me some link ..

It is urgent

thanks......... 

 You can retrieve Xml from database this way http://davidhayden.com/blog/dave/archive/2006/05/04/2936.aspx

or

use technique in following article http://www.sqlservercentral.com/articles/XML/62054/

static void Main(string[] args)

        {

 

            //let us make a connection first

            String str;

            str = "Data Source=TOSHIBA-USER\\SQL2005;Initial Catalog=XmlTest;";

            str = str + "Persist Security Info=True;User ID=sa;Password=sa2005";

            SqlConnection cn = new SqlConnection(str);

            cn.Open();

 

            //Let us make a command

            SqlCommand cmd = new SqlCommand();

            cmd.Connection = cn;

            cmd.CommandText = "GetEmployeeData";

            cmd.CommandType = CommandType.StoredProcedure;

 

            //What we need next is an XMLReader and call

            //ExecuteXMLReader method of SqlCommand.

            XmlReader r;

            r = cmd.ExecuteXmlReader();

 

            //Read the data from XMLReader and Load into

            //the String Builder

            StringBuilder xmlData = new StringBuilder();

            while (r.Read())

            {

                xmlData.Append(r.ReadOuterXml());

            }

 

            //Print the output

            Console.WriteLine(xmlData.ToString());

 

            //Close the Reader and DB Connection

            r.Close();

            cn.Close();

 

        }

Thanks ......

what u have given me are both very near to my need ....but I want to manuplate the content whatever we have got in the XMLDATA variable as I want to get every record one by one related to their parent and assibn it to some control. Is it possible ...........

Thanks for the reply................

Hi santosh,

Reply you here : http://forums.asp.net/t/1315275.aspx