public PersistentDataTable(bool reset)
{
_handler = new DataHandler(_path, _name);
_columns = new DataColumnCollection(_handler);
_rows = new DataRowCollection(_handler);
_handler.Open(false);
}
public PersistentDataTable(string name, bool reset)
{
_handler = new DataHandler(_path, _name);
_name = name;
_columns = new DataColumnCollection(_handler);
_rows = new DataRowCollection(_handler);
_handler.Open(reset);
}
public PersistentDataTable()
{
_handler = new DataHandler(_path, _name);
_columns = new DataColumnCollection(_handler);
_rows = new DataRowCollection(_handler);
_handler.Open(false);
//_columns = _handler.Items;
}
public PersistentDataTable(string path, string filename, bool reset)
{
_handler = new DataHandler(_path, _name);
_path = path;
_name = filename;
_columns = new DataColumnCollection(_handler);
_rows = new DataRowCollection(_handler);
_handler.Open(false);
}
static void Main(string[] args)
{
// Test the column routines
DataHandler dh = new DataHandler("", "test");
dh.Open(true);
DataColumn c = new DataColumn();
c.ColumnName = "first";
c.DataType = System.Type.GetType("System.String");
c.MaxLength = 10;
dh.Add(c);
c = new DataColumn();
c.ColumnName = "second";
c.DataType = System.Type.GetType("System.String");
dh.Add(c);
c = new DataColumn();
c.ColumnName = "third";
c.DataType = System.Type.GetType("System.Int16");
dh.Add(c);
// Update - shorter string
c = new DataColumn();
c.ColumnName = "2";
c.DataType = System.Type.GetType("System.String");
dh.Set(c, 1);
// Update - longer string
c = new DataColumn();
c.ColumnName = "deuxième";
c.DataType = System.Type.GetType("System.String");
dh.Set(c, 1);
c = dh.Get(0);
Console.WriteLine(c.ColumnName);
// Remove - column
c = new DataColumn();
c.ColumnName = "second";
dh.Remove(c);
}
static void Main(string[] args)
{
// Test the row routines
DataHandler dh = new DataHandler("", "test");
dh.Open(true);
DataColumn c = new DataColumn
{
ColumnName = "first",
DataType = System.Type.GetType("System.String"),
MaxLength = 10
};
dh.Add(c);
c = new DataColumn
{
ColumnName = "second",
DataType = System.Type.GetType("System.String")
};
dh.Add(c);
c = new DataColumn
{
ColumnName = "third",
DataType = System.Type.GetType("System.Int16")
};
dh.Add(c);
// Test row routines
DataRow r = new DataRow(dh);
r[0] = "hello";
r[1] = "goodby";
r[2] = 1;
dh.Create(r);
r = new DataRow(dh);
r[0] = "begging";
r[1] = "end";
r[2] = 2;
dh.Create(r);
r = new DataRow(dh);
r[0] = "from";
r[1] = "to";
r[2] = 3;
dh.Create(r);
r = new DataRow(dh);
r[0] = "start";
r[1] = "finish";
r[2] = 4;
dh.Create(r);
// Get the data
Console.WriteLine("Records=" + dh.Records);
for (int i = 0; i < dh.Records; i++)
{
DataRow dr;
dr = dh.Read(i);
for (int j = 0; j < dh.Items; j++)
{
Console.WriteLine(i + " " + j + " '" + dr.ItemArray[j] + "'");
}
}
// Delete some data
dh.Delete(2);
Console.WriteLine("Records=" + dh.Records);
for (int i = 0; i < dh.Records; i++)
{
DataRow dr;
dr = dh.Read(i);
for (int j = 0; j < dh.Items; j++)
{
Console.WriteLine(i + " " + j + " '" + dr.ItemArray[j] + "'");
}
}
}
