private static void ConsoleDump(FlatDatabase.DBase.Recordset recordset)
{
string str = string.Empty;
int i = 0;
foreach (FlatDatabase.ColumnInfo col in recordset.Columns)
{
if (0 != i++)
{
str += sep;
}
str += col.Name;
}
Console.WriteLine(str);
foreach (FlatDatabase.DBase.Record record in recordset)
{
str = string.Empty;
i = 0;
foreach (FlatDatabase.DBase.Column col in record)
{
if (0 != i++)
{
str += sep;
}
str += col.Data;
//break;
}
Console.WriteLine("{0,5} {1}", recordset.Position, str);
//break;
}
}
public MyDataTable(FlatDatabase.DBase.Recordset recordset) : base(recordset.TableName)
{
Recordset = recordset;
foreach (FlatDatabase.ColumnInfo col in recordset.Columns)
{
var column = new DataColumn(col.Name);
column.DataType = col.DataType;
Columns.Add(column);
}
}
private static void OpenRecordset(string filename)
{
var recordset = new FlatDatabase.DBase.Recordset();
if (recordset.Open(filename, System.IO.FileMode.Open))
{
ConsoleDump(recordset);
recordset.Close();
}
}
public DataWindow()
{
InitializeComponent();
//string filename = @"h:\cpcload.dbf";
string filename = "sjov.dbf"; FlatDatabase.DBase.Test.CreateDatabase(filename);
var recordset = new FlatDatabase.DBase.Recordset();
recordset.Open(filename, System.IO.FileMode.Open);
//var table = new MyDataTable(recordset);
Title = string.Format("{0} [{1}] - dbf library", System.IO.Path.GetDirectoryName(recordset.Filename), recordset.TableName);
var gridview = new GridView();
Binding bind;
if (true)
{
foreach (FlatDatabase.ColumnInfo col in recordset.Columns)
{
bind = new Binding();
//bind.Source = recordset;
bind.Converter = new PropertyObjectConverterCol(col);
bind.ConverterParameter = col;
//bind.Mode = BindingMode.OneWay;
var gvcolumn = new GridViewColumn();
gvcolumn.Header = col.Name;
gvcolumn.DisplayMemberBinding = bind;// new Binding(/*col.Name*/); // makes wpf look for a property of this name - which doesn't exist
gridview.Columns.Add(gvcolumn);
}
}
list.View = gridview;
list.ItemsSource = recordset;
//list.DataContext = table;
//list.DataContext = new ObservableCollection<DBase.Recordset>(recordset);
//bind = new Binding();
//bind.Source = recordset;
//bind.Converter = new PropertyObjectConverter();
//bind.ConverterParameter = recordset;
//bind.Mode = BindingMode.OneWay;
//list.SetBinding(ListView.ItemsSourceProperty, bind);
}
