How can i Fill dataset from XML

Question

0.00/5 (No votes)

See more:

I have xml data as given bellow
i am trying to fill dataset from xml string not xml file and i want to convert above xml to datset / datatable

HTML

<reportdata>
  <columns day="Thrusday" date="12/1/2011 12:00:00 AM">
    <column name="cDATA" calculated="0" formula="" value="1" />
    <column name="dDATA" calculated="0" formula="" value="5" />
    <column name="Total_DS" calculated="1" formula="cDATA+dDATA" value="6" />
  </columns>
  <columns day="Friday" date="12/2/2011 12:00:00 AM">
    <column name="cDATA" calculated="0" formula="" value="2" />
    <column name="dDATA" calculated="0" formula="" value="4" />
    <column name="Total_DS" calculated="1" formula="cDATA+dDATA" value="6" />
  </columns> </reportdata>

I am trying to fill dataset from above xml and assign dataset to datagridview

C#

BLL.Dailydrawer oBO = new BLL.Dailydrawer();
             DataTable   DTPrevMonth = oBO.FillPreviousMonths();
 DataRow[] DR = DTPrevMonth.Select(string.Format("MonthId = {0}", PrevMonthId));
                string XML = Convert.ToString(DR[0]["DataXML"]);
               
                DataSet DS = new DataSet();
                System.IO.StringReader xmlSR = new System.IO.StringReader(XML);

                DS.ReadXml(xmlSR, XmlReadMode.IgnoreSchema);

but dataset display nothing.
Please help me urgent how can i do this?

Posted 22-Dec-11 17:29pm

sagar15modi

Updated 22-Dec-11 19:09pm

v3

Add a Solution

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

penigandlakoti · Answer 1 · 2011-12-22T18:07:00

Solution 2

DS.ReadXml(mappath("file.xml"));

Posted 22-Dec-11 18:07pm

penigandlakoti

Updated 22-Dec-11 19:37pm

v2

Comments

RaviRanjanKr 23-Dec-11 1:37am

[Edited]Code is wrapped in pre tag[/Edited]

kaypees87 · Answer 2 · 2011-12-22T18:56:00

Solution 3

Assuming you are working in winforms,

DataSet ds = new DataSet();
            ds.ReadXml(Application.StartupPath.Replace("\\bin\\Debug","")+"\\XMLFile1.xml");

this will load the xml file in dataset, if the xml file is in the root folder..

Posted 22-Dec-11 18:56pm

kaypees87

Updated 22-Dec-11 19:35pm

v2

Comments

RaviRanjanKr 23-Dec-11 1:36am

[Edited]Code is wrapped in pre tag[/Edited]

RaviRanjanKr · Answer 3 · 2011-12-22T19:42:00

Try

DataSet ds = new DataSet();
    ds.ReadXml(@"YourXML FIle");

or
Reference Link :- Fill DataSet with the data from XML[^]

XmlDataDocument xmlDatadoc = new XmlDataDocument();
   xmlDatadoc.DataSet.ReadXml("Your XML File");

   DataSet ds = new DataSet("DatSet Name");
   ds = xmlDatadoc.DataSet;

Reference Link :- Load XML to DataSet[^]

Nigam Patel · Answer 4 · 2011-12-22T18:03:00

Solution 1

Please use below code

string myXMLfile = "C:\\MySchema.xml";
  DataSet ds = new DataSet();
  try
  {
      ds.ReadXml(myXMLfile);
      dataGrid1.DataSource = ds;
      dataGrid1.DataMember = "Cust";
  }
  catch (Exception ex)
  {
      MessageBox.Show(ex.ToString());
  }

Please let me know if it is work for you

Posted 22-Dec-11 18:03pm

Nigam Patel

Comments

sagar15modi 23-Dec-11 0:40am

i am trying to fill dataset from xml string not xml file
and i want to convert above xml to datset / datatable