Example #1
0
        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;
            }
        }
Example #2
0
 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);
     }
 }
Example #3
0
        private static void OpenRecordset(string filename)
        {
            var recordset = new FlatDatabase.DBase.Recordset();

            if (recordset.Open(filename, System.IO.FileMode.Open))
            {
                ConsoleDump(recordset);
                recordset.Close();
            }
        }
Example #4
0
        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);
        }