reading from xml file into datatable and grid view

Question

my xml is like below

<Expression>
    <Field>X</Field>
    <Formula>a+b</Formula>          
</Expression>
<Expression>
    <Field>Y</Field>
    <Formula>a-b</Formula>          
</Expression>
<Expression>
    <Field>Z</Field>
    <Formula>a*b</Formula>          
</Expression>

my c# page

DataSet ds = new DataSet();           
ds.ReadXml(@"C:\\Test.xml");
GridView1.DataSource = ds;
GridView1.DataMember = ds.Tables[0].ToString();
GridView1.DataBind();

it keeps showing me error:

There are multiple root elements. Line 6, position 4.

Add a general root out of the expression elements

kostas ch.
– kostas ch.

2013-12-30 12:02:13 +00:00
Commented Dec 30, 2013 at 12:02 — kostas ch.
– kostas ch., Commented Dec 30, 2013 at 12:02

Sergey Berezovskiy · Accepted Answer · 2013-12-30 12:08:01Z

3

Xml file must have single root element, which have other elements as children. Currently you have several Expression elements on root level. Wrap them into some Expressions element to make your xml file valid:

<Expressions>
  <Expression>
    <Field>X</Field>
    <Formula>a+b</Formula>
  </Expression>
  <Expression>
    <Field>Y</Field>
    <Formula>a-b</Formula>
  </Expression>
  <Expression>
    <Field>Z</Field>
    <Formula>a*b</Formula>
  </Expression>
</Expressions>

Your xml loading code is valid. It creates DataSet with single DataTable named Expression. That table has two columns (Field and Formula) and three rows with data.

edited Dec 30, 2013 at 12:08

answered Dec 30, 2013 at 12:01

Sergey Berezovskiy

237k44 gold badges441 silver badges468 bronze badges

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

Collectives™ on Stack Overflow

reading from xml file into datatable and grid view

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related