Mega Code Archive

 

Categories / C# Tutorial / ADO Net

 

Append columns to DataTable

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 b c ".Split(' ');             dt.Rows.Add(new object[] { dt.Rows.Count + 1, cust[0], cust[1] });             dt.WriteXml("Employees.xml", XmlWriteMode.WriteSchema);                      }      }