DataSet statment[Answered] RSS

• • Reply
  slb2012

  Member

  34 Points

  167 Posts

  DataSet statment

  Mar 06, 2019 01:31 AM|slb2012|LINK

  Which of the following statements is True

  dataSet ds = new DataSet();

  ds.ReadXML("..\..\states.xml", XmlReadMode Auto);

  Responses:

  1. XML data cannot be read into DataSet
  2. The code will run successfully
  3. There are missing verbatim string literals at line 2

  I think the right answer will be number 2, correct?

  Your help is appreciated.  Thanks

• • Reply
  Ackerly Xu

  Contributor

  3500 Points

  1300 Posts

  Re: DataSet statment

  Mar 06, 2019 06:48 AM|Ackerly Xu|LINK

  Hi slb2012,

  It depends , if the first parameter ..\..\states.xml truly refers to an xml file and it is well-formatted, the code could run successfully.

  For example, if   my code is 

     DataSet set = new DataSet();
              set.ReadXml(Server.MapPath("/xmlDemo/dataset.xml"));

  Then I should have dataset.xml in my folder xmlDemo  at root path of my project.

  And below is my xml. song  will be the table name, artist,album,genre .. . will be the column name.

  <music>
                         
                            <song>
                              <artist>Babyface</artist>
                              <genre>RB</genre>
                              <album>Grown and sexy</album>
                              <year>2005</year>
                            </song>
                            <song>
                              <artist>Maria Arredondo</artist>
                              <genre>Pop</genre>
                              <album>Not going under</album>
                              <year>2004</year>
                            </song>
                        
   </music>

  Best regards,

  Ackerly Xu

  MSDN Community Support
  Please remember to click "Mark as Answer" the responses that resolved your issue.
  If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.
• • Reply
  slb2012

  Member

  34 Points

  167 Posts

  Re: DataSet statment

  Mar 06, 2019 08:05 AM|slb2012|LINK

  Thank you for the little orientation you gave me of the XML DataSet path. Yes, if well-formatted, the code could run successfully that is the right answer.