Convert string to datatable with c#

Question

I want to know how to convert this string to datatable. This string is my string:

"<data name=\"Footer\" xml:space=\"preserve\"> <value>Digital Number</value> </data>,<data name=\"lblDisplay\" xml:space=\"preserve\"> <value>Hien thi</value> </data>"

I created table with 2 column named "Name" and "Value":

DataTable tbl = new DataTable();
DataColumn column;
DataRow row;
column = new DataColumn();
column.DataType = System.Type.GetType("System.String");
column.ColumnName = "Name";
tbl.Columns.Add(column);

column = new DataColumn();
column.DataType = System.Type.GetType("System.String");
column.ColumnName = "Value";
tbl.Columns.Add(column);

How can I convert the string to DataTable?

haldo · Accepted Answer · 2019-04-25 16:20:06Z

4

The string you posted looks a lot like xml, but it is not valid xml. It needs a root element (and remove the , comma). I've updated below:

var xmlString = @"<?xml version=""1.0""?>
                  <rootData>
                      <data name=""Footer"" xml:space=""preserve""> 
                          <value>Digital Number</value> 
                      </data>
                      <data name=""lblDisplay"" xml:space=""preserve"">
                          <value>Hien thi</value> 
                      </data>
                  </rootData>";

DataSet has a method ReadXml() which

... provides a way to read either data only, or both data and schema into a DataSet from an XML document...

Knowing that, now you can create a DataSet and use a StringReader to read the Xml straight into the DataSet.

var ds = new DataSet();
using (var reader = new StringReader(xmlString))
{
    ds.ReadXml(reader);
}

Then, all you need to do is extract the data from the DataSet:

Console.WriteLine($"{ds.Tables[0].Rows[0]["name"]}: {ds.Tables[0].Rows[0]["value"]}");

// output
Footer: Digital Number

If you want a DataTable just do:

 DataTable dt = ds.Tables[0];

See this fiddle.

edited Apr 25, 2019 at 16:20

answered Apr 25, 2019 at 10:24

haldo

17k8 gold badges57 silver badges61 bronze badges

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

1 Comment

dat Over a year ago

thanks so much for your help, i solved it with your ideal, my string acctually is from a resource file.

Collectives™ on Stack Overflow

Convert string to datatable with c#

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related