How to generate xml file with specific structure from datatables?

Question

Q :

According to some choices of the user, i will get set of Datatables from the database.

i have three datatabels:Teachers,Subjects,ClassRooms

and I want an xml file with the following structure:

<timetable importtype="database" options="idprefix:id">

<teachers options="" columns="id,name,short">

</teachers>

<subjects options="" columns="id,name,short">

</subjects>

<classrooms options="" columns="id,name,short">

</classrooms>

</timetable>

Now How to generate xml file with the previous structure and fill the xml file data from the data tables?

ex:

<teachers options="" columns="id,name,short">
<teacher id="a" name="jhon" short="jo"/>
<teacher id="b" name="philips" short="Ph"/>
<teacher id="c" name="sara" short="Sa"/>
</teachers>

From teacher datatable.

please details answer with sample example as possible.

EDIT :

 private static void ConvertDataTableToXML(string schemaFile, DataTable dtTeacher, DataTable dtSubject, DataTable dtClassRoom)
        {
            XDocument doc = new XDocument();
            //Read the teachers element from xml schema file
            XElement teachers = XDocument.Load(schemaFile).Descendants("teachers").SingleOrDefault();
            XElement subjects = XDocument.Load(schemaFile).Descendants("subjects").SingleOrDefault();
            XElement classes = XDocument.Load(schemaFile).Descendants("classrooms").SingleOrDefault();

            if (teachers != null)
            {
                foreach (DataRow row in dtTeacher.Rows)
                {
                    XElement teacher = new XElement("teacher");
                    teacher.SetAttributeValue("id", row["id"]);
                    teacher.SetAttributeValue("name", row["name"]);
                    teacher.SetAttributeValue("short", row["name"].ToString().Substring(0, 2));
                    teachers.Add(teacher);
                }
            }

            if (subjects != null)
            {
                foreach (DataRow row in dtSubject.Rows)
                {
                    XElement subject = new XElement("subject");
                    subject.SetAttributeValue("id", row["num"]);
                    subject.SetAttributeValue("name", row["name"]);
                    subject.SetAttributeValue("short", row["name"].ToString().Substring(0, 2));

                    subjects.Add(subject);
                }
            }

            if (classes != null)
            {
                foreach (DataRow row in dtClassRoom.Rows)
                {
                    XElement cls = new XElement("classroom");
                    cls.SetAttributeValue("id", row["id"]);
                    cls.SetAttributeValue("name", row["name"]);
                    cls.SetAttributeValue("short", row["name"].ToString().Substring(0, 2));

                    classes.Add(cls);
                }

            }

            XElement xml = new XElement("timetable",
                                 new XAttribute("importtype", "database"),
                                 new XAttribute("options", "idprefix:id"),teachers,subjects,classes
                         );
            doc.Add(xml);
            string dirPath = System.Web.HttpContext.Current.Server.MapPath("~/import");
            string targetFileName = Path.Combine(dirPath, "import.xml");
            int counter = 1;
            while (System.IO.File.Exists(targetFileName))
            {
                counter++;
                targetFileName = Path.Combine(dirPath,
                    "import" + counter.ToString() + ".xml");
            }

            doc.Save(targetFileName);
        }

KV Prajapati · Accepted Answer · 2011-12-06 10:02:35Z

1

You may try to read and update XML document using Linq-XML.

Have a look at sample:

//Read the teachers element from xml schema file
XElement teachers = XDocument.Load(schemaFile).Descendants("teachers").SingleOrDefault();

if (teachers != null)
{
    DataTable dt = new DataTable();
    dt.Columns.Add("id");
    dt.Columns.Add("name");


    dt.Rows.Add("1", "john");
    dt.Rows.Add("2", "philips");
    dt.Rows.Add("3", "sara");

    XDocument doc = new XDocument();
    foreach (DataRow row in dt.Rows)
    {
        XElement teacher = new XElement("teacher");
        teacher.SetAttributeValue("id", row["id"]);
        teacher.SetAttributeValue("name", row["name"]);
        teacher.SetAttributeValue("short", row["name"].ToString().Substring(0,2));

        teachers.Add(teacher);
    }
    doc.Add(teachers);
    doc.Save(newFilename);
 }

edited Dec 6, 2011 at 10:02

answered Dec 6, 2011 at 9:31

KV Prajapati

94.8k20 gold badges151 silver badges188 bronze badges

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

5 Comments

Anyname Donotcare Over a year ago

hmmmm , U miss understood the question.I don't want to read xml file , i want to generate xml file with specific schema from datatables?

Anyname Donotcare Over a year ago

i have three datatabels:Teachers,Subjects,ClassRooms. From these datarables ,i wanna to generate an xml file with the previous schema.

Anyname Donotcare Over a year ago

I can customize the datatable but at least two columns (id,name)

Anyname Donotcare Over a year ago

Great , but the new file becomes

<teachers options="" columns="id,name,short"> <teacher id="a" name="jhon" short="jo"/> <teacher id="b" name="philips" short="Ph"/> <teacher id="c" name="sara" short="Sa"/> </teachers>

where is the rest of my schema I mean the root element and (subject,classroom ) even empty

Anyname Donotcare Over a year ago

I want the result like this:

<timetable importtype="database" options="idprefix:id">  <teachers options="" columns="id,name,short"> <teacher id="a" name="jhon" short="jo"/> <teacher id="b" name="philips" short="Ph"/> <teacher id="c" name="sara" short="Sa"/> </teachers>   <subjects options="" columns="id,name,short">  </subjects>  <classrooms options="" columns="id,name,short">  </classrooms>  </timetable>

Collectives™ on Stack Overflow

How to generate xml file with specific structure from datatables?

EDIT :

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

EDIT :

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related