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);
}
/// <summary>
/// Add a new item at the end of the list
/// </summary>
/// <param name="item"></param>
public void Add(DataColumn column)
{
bool match = false;
for (int item = 0; item < _handler.Items; item++)
{
if (_handler.Get(item).ColumnName == column.ColumnName)
{
match = true;
}
}
if ((match == false) || (_handler.Items == 0))
{
_handler.Add(column);
}
else
{
throw new DuplicateNameException();
}
}
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] + "'");
}
}
}
