Writing Data From Datatable into xml

See more:

C#

DataTable dts = new DataTable();
                             dts.Columns.Add("heading_name");
                             dts.Columns.Add("sub_heading_name");
                             dts.Columns.Add("detail_text");
                             DataRow drs = dts.NewRow();
                             string heading_name = dr["heading_name"].ToString();
                             drs["heading_name"] = heading_name;
                             string detail_text = dr2["detail_text"].ToString();
                             drs["detail_text"] = detail_text;
                             dts.Rows.Add(drs);
                             DataSet mDs = new DataSet();
                             dts.TableName = "MyTable";
                             mDs.Tables.Add(dts);
                             mDs.WriteXmlSchema(Server.MapPath("XMLFile.xml").ToString());

I have a datatable, added columns and then I add datarows assigning from foreach loop. Then I create a dataset adding my datatable to it and call writexmlschema method. The problem is that my XML file is created but I it has columns not the actual data which is comin from database. I have watched in debug mode also in my variable data is coming but in XML only columns name are being shown.

I want it to write my data from the database into XML can anybody help me?



[Edit Keith Barrow:] The OP is speaking like an adult. Agreed the English is pretty poor, so I've fixed it

The reason the orignal text looked childish is because of the way the Arabic alphabet(used in Pakistan) works: The letter "Tha" ﺙ makes the sound "th" like the greek Theta or Booth. The letter dhal ﺫ which also sounds "th" (but as in "this" or "the" rather than "booth") but is normally transliterated to "dh" or sometimes "d". What the OP did was choose a wrong, but common English transliteration. This is akin to a German mixing up v/w and Arabs confusing b/p and f/v or English people confusing ﺱ/ﺹ or ﺡ/ﺥ/ﻩ or ﻕ/ﻙ or ﺽ/ﺩ for that matter. Unfortunately for the OP it does look like kiddie-speak because the letters he has confused happen sound the same as a child who can't form the "th" sound properly yet. Additionally the OP has also not used punctuation as Arabic text doesn't usually need it.