private void btnBrowse_Click(object sender, RoutedEventArgs e) { OpenFileDialog fileDialog = new OpenFileDialog(); fileDialog.DefaultExt = ".accdb"; fileDialog.Filter = "Microsoft Access Database (.accdb) | *.accdb*"; if (fileDialog.ShowDialog() == true) { txtFileName.Text = fileDialog.FileName; fileName = txtFileName.Text.ToString(); EnvironmentConfig.DataSourceValue = Convert.ToString(fileName.Trim()); DataSet dd = AccessDbLoader.LoadFromFile(); var lll = (from lead in dd.Tables["[tbl_Lead]"].AsEnumerable() join member in dd.Tables["[tbl_Member]"].AsEnumerable() on lead.Field <int>("ID") equals member.Field <int>("LeadId") select new { AadhaarNumber = member.Field <string>("AadharNumber"), Name = member.Field <string>("Member_Name"), Village = lead.Field <string>("Village"), Mandal = lead.Field <string>("Mandal"), BranchName = lead.Field <string>("BranchName") }).ToList(); grdView.ItemsSource = lll; } }
static void Main(string[] args) { ExportAccessTabletoExcel.ExportQuery(@"C:\Projects\CHIA\Cerner\Cerner_Multum_en-US_249_180601.accdb", "drc_gestational_age_non_continuous_infusion", @"C:\Projects\CHIA\drc_gestational_age_non_continuous_infusion.xlsx"); ReadExcelFileReturnList GetGetExcel = new ReadExcelFileReturnList(); GetGetExcel.getExcelFile(@"C:\Projects\CHIA\drc_gestational_age_non_continuous_infusion.xlsx", 1); //List<string> ExcelList = new List<string>(); //ReadExcelFile GetExcel = new ReadExcelFile(@"C:\Projects\CHIA\Copyof20180513_drc_age2_updates_US_CA_v249.xlsx"); ReadExcelFile GetExcel = new ReadExcelFile(); //ReadExcelFile GetExcel = new ReadExcelFile(); //GetExcel.ExcelList = ReadExcelFile.getExcelFile(); List <string> ExcelList = GetExcel.getExcelFile(@"C:\Projects\CHIA\Copyof20180513_drc_age2_updates_US_CA_v251.xlsx", 3); //Pass in Excel path and string //List<string> ExcelList2 = GetExcel2.getExcelFile(@"C:\Projects\CHIA\Copyof20180513_drc_age2_updates_US_CA_v251.xlsx", 3); List <string> ExcelList2 = GetExcel.getExcelFile(@"C:\Projects\CHIA\drc_gestational_age_non_continuous_infusion.xlsx", 1); CompareList CompareTwoExcelLists = new CompareList(); //List<string> ReturnLists = CompareTwoLists.Contains(ExcelList, DataList); IEnumerable <string> ReturnDiffLists = CompareTwoExcelLists.Contains(ExcelList, ExcelList2); PrintToFile.Print(ExcelList); PrintToFile.Print(ExcelList2); PrintToFile.Print(ReturnDiffLists); //ConsoleWriteLineList.DumpExcelSet(ExcelList); // Load an Access ACCDB file DataSet ds1 = AccessDbLoader.LoadFromFile(@"C:\Projects\CHIA\Cerner\Cerner_Multum_en-US_249_180601.accdb"); //DataSet ds1 = AccessDbLoader.LoadFromFile(@"C:\Projects\CHIA\Cerner\Cerner_Multum_en-CA_249_180601.accdb"); //DataSet ds1 = AccessDbLoader.LoadFromFile(@"C:\Projects\CHIA\Lexi\Cerner_LexiComp_en-US_249_180601.accdb"); List <string> DataList = DataSetToList.DumpDataSet(ds1); //DumpDataSetToConsole.DumpDataSet(ds1); //var firstNotSecond = ExcelList.Except(DataList).ToList(); //var secondNotFirst = DataList.Except(ExcelList).ToList(); CompareList CompareTwoLists = new CompareList(); //List<string> ReturnLists = CompareTwoLists.Contains(ExcelList, DataList); IEnumerable <string> ReturnLists = CompareTwoLists.Contains(ExcelList, DataList); PrintToFile.Print(ExcelList); PrintToFile.Print(DataList); PrintToFile.Print(ReturnLists); //ConsoleWriteLineList.DumpExcelSet(ReturnLists); Console.ReadLine(); }