Problem with reteriving xml data from sql data base.

[prasadbuddhika]

I have a table which have a filed which is xml type, and some more fields such as name and id.i want to read the xml field as well as the other fields in C#, i searched and got this

XmlReader rdr = cmd.ExecuteXmlReader();

but i want to get the other data in the table too. is there any option to do this using one command , or do i have to call two times to get the data. any idea. thanks in advance.

[abhinish]

XmlDocument document = new XmlDocument();
using (SqlDataReader dr = oComm.ExecuteReader())
{
if (dr.Read())
{
if (!dr.IsDBNull(0))
document.Load(dr.GetSqlXml(0).CreateReader());
}
}

I think this is what you want

abhinav