Help With Better Databinding

AgentSmith · March 7th, 2009, 10:10 PM

I get an array of Document objects from a web service call. Each Document object has an array of Property objects. Each Property object has two properties, Name and Value. Such as

<Docs>
<Doc>
<Property Name="Title" Value="Test Title">
<Property Name="Category" Value="Test Subject">
</Doc>
</Docs>

My question is this, what is the best method for changing this array of Document objects into a bindable data source for a datagrid. In the past I've done the following, serialize the object to xml and run an xsl transformation on it to make the below xml and then read that xml into a datatable. I'm looking for a better way to make the Documents array bindable. Can I get some suggestions please?

<Docs>
<Doc>
<Title>Test Title</Title>
<Category>Test Subject</Category>
</Doc>
</Docs>

PeterPeiGuo · March 8th, 2009, 04:05 PM

Assume xml is a String that contains the xml document:

Code:

 
GridView1.DataSource = from p in XDocument.Parse(xml).Elements("Docs").Elements("Doc") select new { Title = p.Elements().ElementAt(0).Attribute("Value").Value, Category = p.Elements().ElementAt(1).Attribute("Value").Value };
GridView1.DataBind();