static void Main(string[] args) { System.Data.DataTable dt = new System.Data.DataTable("test_table"); System.Data.DataColumn dc = new System.Data.DataColumn("id"); dc.DataType = System.Type.GetType("System.Int32"); dc.Unique = true; dt.Columns.Add(dc); dc = new System.Data.DataColumn("name"); dc.DataType = System.Type.GetType("System.String"); dt.Columns.Add(dc); System.Data.DataRow dr = dt.NewRow(); dr["id"] = 1; dr["name"] = "jeremy"; Console.WriteLine("Fields=" + dr.ItemArray.Length);; dt.Rows.Add(dr); Console.WriteLine("Records=" + dt.Rows.Count); foreach (System.Data.DataRow r in dt.Rows) { Console.WriteLine(r["id"] + "," + r["name"]); } try { dt.Columns.Remove("Test"); Console.WriteLine("Removed"); } catch { }; System.Data.DataRow[] rs = dt.Select(); foreach (System.Data.DataRow r in rs) { Console.WriteLine(r["id"] + "," + r["name"]); } dt.Dispose(); Console.WriteLine("----------"); PersistentDataTable pdt = new PersistentDataTable("test_table", true); DataColumn pdc; try { pdc = new DataColumn("id"); pdc.DataType = System.Type.GetType("System.Int32"); //pdc.Unique = true; pdt.Columns.Add(pdc); } catch { }; try { pdc = new DataColumn("name"); pdc.DataType = System.Type.GetType("System.String"); pdt.Columns.Add(pdc); } catch { }; DataRow pdr = pdt.NewRow(); pdr["id"] = 1; pdr["name"] = "jeremy"; Console.WriteLine("Fields=" + pdr.ItemArray.Length); pdt.Rows.Add(pdr); Console.WriteLine("Records=" + pdt.Rows.Count); foreach (DataRow r in pdt.Rows) { Console.WriteLine(r["id"] + "," + r["name"]); } try { pdt.Columns.Remove("Test"); Console.WriteLine("Removed"); } catch { }; DataRow[] prs = pdt.Select(); foreach (DataRow r in prs) { Console.WriteLine(r["id"] + "," + r["name"]); } pdt.Dispose(); // Need to agree if this deletes the datatable files }
public text(PersistentDataTable table) { _table = table; _columns = null; }
public DataRow(PersistentDataTable table) { _table = table; _handler = _table.Handler; }