Csharp/CSharp Tutorial/XML/Xml DataTable
Update DataTable and output Xml
<source lang="csharp">using System; using System.Data; using System.IO; using System.Collections.Generic; using System.Text;
class Program { static DataTable dt; static void Main(string[] args) { dt = new DataTable("Employees"); dt.ReadXml("Employees.xml"); Console.WriteLine("{0} Employees Found", dt.Rows.Count); foreach (DataRow row in dt.Rows) { Console.WriteLine("[{0}] {1} {2}", row["EmployeeID"], row["FirstName"], row["LastName"]); } //dt.Columns.Add("EmployeeID", typeof(int)); //dt.Columns.Add("FirstName", typeof(string)); // dt.Columns.Add("LastName", typeof(string)); // dt.Rows.Add(new object[] { 1, "A", "H" }); // dt.Rows.Add(new object[] { 2, "J", "D" }); string[] cust = "a bc c".Split(" "); dt.Rows.Add(new object[] { dt.Rows.Count + 1, cust[0], cust[1] }); dt.WriteXml("Employees.xml", XmlWriteMode.WriteSchema); } }</source>
Using DataTable to read Xml
<source lang="csharp">using System; using System.Data; using System.Collections.Generic; using System.Text;
class Program { static void Main(string[] args) { DataTable dt = new DataTable("Employees"); dt.ReadXml("Employees.xml"); DataTableReader dtr = dt.CreateDataReader(); while (dtr.Read()) { Console.WriteLine(dtr["EmployeeID"]); Console.WriteLine(dtr["FirstName"]); Console.WriteLine(dtr["LastName"]); } } }</source>