public TrashSystemTablePage() { InitializeComponent(); string databaseDirectory = AppSettingConfig.DbfFilePath(); string invo = "INVO.dbf"; string invoSql = "SELECT TOP 100 * FROM " + invo + " ORDER BY MONTH DESC"; DataTable invoDt = GetOleDbDbfDataTable(databaseDirectory, invoSql); DataGridInvo.ItemsSource = invoDt.DefaultView; string invosub = "INVOSUB.dbf"; string invosubSql = "SELECT TOP 100 * FROM " + invosub + " WHERE C_01 = 'B016' ORDER BY IN_DATE DESC,TIME DESC";//+ " where IN_DATE Between cDate('" + DateTime.Now.AddDays(-1).ToString() + "') and cDate('" + DateTime.Now.ToString() + "') "; DataTable invosubDt = GetOleDbDbfDataTable(databaseDirectory, invosubSql); DataGridInvoSub.ItemsSource = invosubDt.DefaultView; string item = "ITEM.dbf"; string itemSql = "SELECT * FROM " + item; DataTable itemDt = GetOleDbDbfDataTable(databaseDirectory, itemSql); DataGridItem.ItemsSource = itemDt.DefaultView; //List<string> I_03 = new List<string>(); //foreach (DataRow itemRow in itemDt.Rows) //{ // I_03.Add(itemRow["I_03"].ToString()); //} //var x = I_03.GroupBy(y => y).Where(w => w.Count() > 1).Select(s => s.Key); string cust = "CUST.dbf"; string custoSql = "SELECT TOP 100 * FROM " + cust; DataTable custDt = GetOleDbDbfDataTable(databaseDirectory, custoSql); DataGridCust.ItemsSource = custDt.DefaultView; string purc = "PURC.dbf"; string purcSql = "SELECT TOP 100 * FROM " + purc + " ORDER BY MONTH DESC"; DataTable purcDt = GetOleDbDbfDataTable(databaseDirectory, purcSql); DataGridPurc.ItemsSource = purcDt.DefaultView; string purcSub = "PURCSUB.dbf"; string purcSubSql = "SELECT TOP 100 * FROM " + purcSub + " ORDER BY MONTH DESC"; DataTable purcSubDt = GetOleDbDbfDataTable(databaseDirectory, purcSubSql); DataGridPurcsub.ItemsSource = purcSubDt.DefaultView; string inCash = "IN_CASH.dbf"; string inCashSql = "SELECT * FROM " + inCash; DataTable inCashDt = GetOleDbDbfDataTable(databaseDirectory, inCashSql); DataGridInCash.ItemsSource = inCashDt.DefaultView; }