Binding XML to wpf datagrid

Question

I have a WPF data grid and an xmlString and am having problems binding it.

I have read this post and followed the instructions but cant get it to work.

I see the column with the title but no data is in there. Any ideas?

I should say the code behind is called when a button is clicked after the window has loaded.

Here is my XAML

<DataGrid x:Name="dtgMain" ItemsSource="{Binding Path=Elements[panel]}">
    <DataGrid.Columns>
        <DataGridTextColumn Header="PanelCode" Binding="{Binding Path=Element[panelCode].InnerText}"/>
    </DataGrid.Columns>
</DataGrid>

Here is my codebehind

System.IO.StringReader reader = new System.IO.StringReader(response);
            XElement results = XElement.Load(reader);
            dtgMain.DataContext = results;

here is my xml

<data>
  <load count="2">true
    <panel index="10">
      <panelCode>100072
      </panelCode>
      <panelName>COM0100072*A
      </panelName>
      <panelPart>100072
      </panelPart>
      <numberLayers>4
      </numberLayers>
      <panelSize.display>21.0 x 24.0
      </panelSize.display>
      <lastEdited.display>16/11/2011 17:13:39
      </lastEdited.display>
      <panelStatus.display>Measurements Stored
      </panelStatus.display>
      <lastEditor>admin
      </lastEditor>
      <numberBonds>1
      </numberBonds>
      <numberSubComponents>0
      </numberSubComponents>
    </panel>
    <panel index="11">
      <panelCode>100352
      </panelCode>
      <panelName>COM0100352*C
      </panelName>
      <panelPart>100352
      </panelPart>
      <numberLayers>8
      </numberLayers>
      <panelSize.display>18.0 x 24.0
      </panelSize.display>
      <lastEdited.display>16/11/2011 17:18:47
      </lastEdited.display>
      <panelStatus.display>Measurements Stored
      </panelStatus.display>
      <lastEditor>admin
      </lastEditor>
      <numberBonds>1
      </numberBonds>
      <numberSubComponents>0
      </numberSubComponents>
    </panel>
  </load>
</data>

In my opinion you should be using the XmlDocument family of XML classes as they support Binding.XPath. — brunnerh
– brunnerh, Commented Jan 13, 2012 at 19:11
H.B would you please be able to post a code example or at least link to some examples? — user589195
– user589195, Commented Jan 14, 2012 at 10:04
Logically there is an example in the XPath property documentation i linked to. — brunnerh
– brunnerh, Commented Jan 14, 2012 at 13:59
HB there are 2 things that stick out with that example. The first is that its using a static xml file instead of a programatically generated on as in my example. The second thing is that its bingding to a list box instead of a datagrid. Would you be able to give examples of how to use this in my situation? — user589195
– user589195, Commented Jan 16, 2012 at 9:32

Scott · Accepted Answer · 2012-01-16 16:40:57Z

2

XElement does not have an 'InnerText' property.

Have you tried using

Binding="{Binding Path=Element[panelCode].Value}"

instead?

Edit:

I just tested with a sample project and the only other change (besides using .Value) is changing your ItemsSource of your DataGrid to include the 'load' node:

ItemsSource="{Binding Path=Element[load].Elements[panel]}"

So your data grid will look like the following:

<DataGrid x:Name="dtgMain" ItemsSource="{Binding Path=Element[load].Elements[panel]}">
    <DataGrid.Columns>
       <DataGridTextColumn Header="PanelCode" Binding="{Binding Path=Element[panelCode].Value}"/>
    </DataGrid.Columns>
</DataGrid>

edited Jan 16, 2012 at 16:40

answered Jan 13, 2012 at 17:16

Scott

12.1k6 gold badges51 silver badges55 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

user589195 Over a year ago

I started off using that and am sure I had the same situation. I will change and show the result :D

user589195 Over a year ago

Using value results in the same situation of nothing being displayed.

Scott Over a year ago

I've updated my answer to include a solution that I have tested (in .NET 4) and verified it works. It appears the initial <data> node is treated as the root, but you cannot just ignore the <load> node and skip straight to <panel> as you were doing.

Collectives™ on Stack Overflow

Binding XML to wpf datagrid

1 Answer 1

Edit:

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Edit:

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related