Click here to Skip to main content
15,887,135 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
hey , hi 2 all ......

i want to send my data in xml format , i done this in this way ....


[WebMethod]
public XmlElement CompXml(string CourseId)
{
XmlElement Xel = null;
DataTable dt = new DataTable();
dt=MLT.GetDataTablefor1Parameters("GetCompltCDetailForCourse","@CourseID",CourseId.ToString());
DataSet ds = new DataSet();
ds.Tables.Add(dt);
XmlDataDocument XDD = new XmlDataDocument(ds);
Xel = XDD.DocumentElement;
return Xel;


this is working but the problem is that i want to send data in the format of as given example .....


XML
<?xml version="1.0" encoding="utf-8"?>
<Course>
  <Chapter Name="ABC">
  <Module Name="Module1">
  <Page Name="Polio">
    <Image>http://dl.dropboxusercontent.com/u/71411762/faiyyaz/b1.png</Image>
    <Text>http://dl.dropboxusercontent.com/u/71411762/faiyyaz/1.mp3</Text>
    <Sound>Shaking hands briefly</Sound>
  </Page>
 
 <Page Name="Malaria">
    <Work>http://dl.dropboxusercontent.com/u/71411762/faiyyaz/g1.png</Work>
    <City>http://dl.dropboxusercontent.com/u/71411762/faiyyaz/2.mp3</City>
    <Amount>200</Amount>
  </Page>

<Page Name="Typhoid">
    <Work>http://dl.dropboxusercontent.com/u/71411762/faiyyaz/b2.png</Work>
    <City>http://dl.dropboxusercontent.com/u/71411762/faiyyaz/3.mp3</City>
    <Amount>2002</Amount>
  </Page>

</Module>

<Module Name="Module2">
  <Page Name="Polio123">
    <Work>http://dl.dropboxusercontent.com/u/71411762/faiyyaz/g2.png</Work>
    <City>http://dl.dropboxusercontent.com/u/71411762/faiyyaz/4.mp3</City>
    <Amount>200123</Amount>
  </Page>
 
 <Page Name="Malaria123">
    <Work>http://dl.dropboxusercontent.com/u/71411762/faiyyaz/b3.png</Work>
    <City>http://dl.dropboxusercontent.com/u/71411762/faiyyaz/5.mp3</City>
    <Amount>200</Amount>
  </Page>
</Module>

  </User>

  <User Name="XYZ">
  <Page Name="TB">

   <Work>http://dl.dropboxusercontent.com/u/71411762/faiyyaz/g3.png</Work>
    <City>http://dl.dropboxusercontent.com/u/71411762/faiyyaz/6.mp3</City>
    <Amount>1000</Amount>
</Page>



  </User>

<User Name="Faiyaz">
<Module Name="Company">
  <Page Name="FB">

   <Work>http://dl.dropboxusercontent.com/u/71411762/faiyyaz/b4.png</Work>
    <City>http://dl.dropboxusercontent.com/u/71411762/faiyyaz/7.mp3</City>
    <Amount>100000</Amount>
</Page>
<Page Name="FB1">

   <Work>http://dl.dropboxusercontent.com/u/71411762/faiyyaz/g4.png</Work>
    <City>http://dl.dropboxusercontent.com/u/71411762/faiyyaz/8.mp3</City>
    <Amount>100000</Amount>
</Page>

</Module>

<Module Name="Company123">
  <Page Name="FB123">

   <Work>http://dl.dropboxusercontent.com/u/71411762/faiyyaz/b5.png</Work>
    <City>http://dl.dropboxusercontent.com/u/71411762/faiyyaz/9.mp3</City>
    <Amount>100000</Amount>
</Page>
<Page Name="FB123">

   <Work>http://dl.dropboxusercontent.com/u/71411762/faiyyaz/g5.png</Work>
    <City>http://dl.dropboxusercontent.com/u/71411762/faiyyaz/10.mp3</City>
    <Amount>100000</Amount>
</Page>

<Page Name="FB456">

   <Work>http://dl.dropboxusercontent.com/u/71411762/faiyyaz/b2.png</Work>
    <City>http://dl.dropboxusercontent.com/u/71411762/faiyyaz/1.mp3</City>
    <Amount>100000</Amount>
<Test>Test Demo</Test>

</Page>


</Module>

  </User>
  </UserData>


Please give any idea frnds ... ?
Posted
Updated 24-Oct-13 19:25pm
v2

I am not sure if it will be useful solution for issue. You build XSL and then transform from dataset generated XML to format you need.
 
Share this answer
 
Hi
use below code and sample xml then execute

buttonclick()
{
// just read xml.so only need to know how to arrange Datatables inside DataSet.
DataSet dtt = new DataSet();
dtt.ReadXml(AppDomain.CurrentDomain.BaseDirectory + "XMLFile1.xml");

//just get xml from using above dataset check whether getting same xml or not.
XmlDataDocument XDD = new XmlDataDocument(dtt);
XmlElement Xel =XDD.DocumentElement;
string testdata = XDD.InnerXml;
}



XMLFile1.xml

XML
<?xml version="1.0" encoding="utf-8" ?>
<Course>
  <Chapter Name="ABC">
    <Module Name="Module1">
      <Page Name="Polio">
        <Image>http://dl.dropboxusercontent.com/u/71411762/faiyyaz/b1.png</Image>
        <Text>http://dl.dropboxusercontent.com/u/71411762/faiyyaz/1.mp3</Text>
        <Sound>Shaking hands briefly</Sound>
      </Page>

      <Page Name="Malaria">
        <Work>http://dl.dropboxusercontent.com/u/71411762/faiyyaz/g1.png</Work>
        <City>http://dl.dropboxusercontent.com/u/71411762/faiyyaz/2.mp3</City>
        <Amount>200</Amount>
      </Page>

      <Page Name="Typhoid">
        <Work>http://dl.dropboxusercontent.com/u/71411762/faiyyaz/b2.png</Work>
        <City>http://dl.dropboxusercontent.com/u/71411762/faiyyaz/3.mp3</City>
        <Amount>2002</Amount>
      </Page>

    </Module>
    <Module Name="Module2">
      <Page Name="Polio123">
        <Work>http://dl.dropboxusercontent.com/u/71411762/faiyyaz/g2.png</Work>
        <City>http://dl.dropboxusercontent.com/u/71411762/faiyyaz/4.mp3</City>
        <Amount>200123</Amount>
      </Page>

      <Page Name="Malaria123">
        <Work>http://dl.dropboxusercontent.com/u/71411762/faiyyaz/b3.png</Work>
        <City>http://dl.dropboxusercontent.com/u/71411762/faiyyaz/5.mp3</City>
        <Amount>200</Amount>
      </Page>
    </Module>
  </Chapter>
  <UserData>
    <User Name="XYZ">
      <Page Name="TB">

        <Work>http://dl.dropboxusercontent.com/u/71411762/faiyyaz/g3.png</Work>
        <City>http://dl.dropboxusercontent.com/u/71411762/faiyyaz/6.mp3</City>
        <Amount>1000</Amount>
      </Page>



    </User>
    <User Name="Faiyaz">
      <Module Name="Company">
        <Page Name="FB">

          <Work>http://dl.dropboxusercontent.com/u/71411762/faiyyaz/b4.png</Work>
          <City>http://dl.dropboxusercontent.com/u/71411762/faiyyaz/7.mp3</City>
          <Amount>100000</Amount>
        </Page>
        <Page Name="FB1">

          <Work>http://dl.dropboxusercontent.com/u/71411762/faiyyaz/g4.png</Work>
          <City>http://dl.dropboxusercontent.com/u/71411762/faiyyaz/8.mp3</City>
          <Amount>100000</Amount>
        </Page>

      </Module>

      <Module Name="Company123">
        <Page Name="FB123">

          <Work>http://dl.dropboxusercontent.com/u/71411762/faiyyaz/b5.png</Work>
          <City>http://dl.dropboxusercontent.com/u/71411762/faiyyaz/9.mp3</City>
          <Amount>100000</Amount>
        </Page>
        <Page Name="FB123">

          <Work>http://dl.dropboxusercontent.com/u/71411762/faiyyaz/g5.png</Work>
          <City>http://dl.dropboxusercontent.com/u/71411762/faiyyaz/10.mp3</City>
          <Amount>100000</Amount>
        </Page>

        <Page Name="FB456">

          <Work>http://dl.dropboxusercontent.com/u/71411762/faiyyaz/b2.png</Work>
          <City>http://dl.dropboxusercontent.com/u/71411762/faiyyaz/1.mp3</City>
          <Amount>100000</Amount>
          <Test>Test Demo</Test>

        </Page>


      </Module>

    </User>
  </UserData>
</Course>
 
Share this answer
 
Comments
GDdixit 25-Oct-13 2:41am    
But my problem is that i have not xml file hardcopy . i am gnerating xml structure from datatable. and fetching data in datatable from database .

and than after fetching data i generate xml format for webservices . but its not satisfied the format as i want .. i hope u understand ... ... ?
GDdixit 25-Oct-13 2:48am    
how i arreange them as ....

<course>
<chapter name="">
<module name="">
<page>p1</page>
<page>p2</page>

<module name="">
<page>p3</page>
<page>p4</page>



<chapter name="">
......

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900