private void getDataButtonClick(object sender, EventArgs e) { Database1Entities db = new Database1Entities(); List <String> pkts = (from x in db.Pkts select x.kodePkt).ToList(); pktComboBox.DataSource = pkts; /** * load semua file pkt **/ loadForm lf = new loadForm(); lf.Show(); Application.DoEvents(); FolderBrowserDialog fdb = new FolderBrowserDialog(); String folderPath; if (fdb.ShowDialog() == DialogResult.OK) { folderPath = fdb.SelectedPath; foreach (String temp in pkts) { String filePath = folderPath + "\\" + temp + ".xlsx"; //Console.WriteLine(filePath); //filePath = Variables.parentFolder + Variables.todayYear + "\\" + Variables.todayMonth + "\\" + Variables.todayDay + "\\" + temp + ".xlsx"; //Console.WriteLine(filePath); bool found = false; try { Util.openExcel(filePath); //Reinisialisasi sheetIndex = 0; dataGridView1.Rows.Clear(); dataGridView1.Refresh(); DataSet data = Util.openExcel(filePath); ds.Add(data); List <transaksiPkt> pktSheets = loadDataIntoClass(data); collectionTransaksiPkt.Add(pktSheets); List <String> sheetnames = new List <String>(); for (int i = 0; i < data.Tables.Count; i++) { sheetnames.Add(data.Tables[i].TableName.ToString()); } listSheetNames.Add(sheetnames); //comboBox1.DataSource = sheetnames; //loadGridView(data); Util.closeExcel(); found = true; } catch (Exception err) { } if (!found) { try { filePath = folderPath + "\\" + temp + ".xls"; //Console.WriteLine(filePath); //filePath = Variables.parentFolder + Variables.todayYear + "\\" + Variables.todayMonth + "\\" + Variables.todayDay + "\\" + temp + ".xls"; //Console.WriteLine(filePath); //Reinisialisasi sheetIndex = 0; dataGridView1.Rows.Clear(); dataGridView1.Refresh(); DataSet data = Util.openExcel(filePath); List <String> sheetnames = new List <String>(); for (int i = 0; i < data.Tables.Count; i++) { sheetnames.Add(data.Tables[i].TableName.ToString()); //Console.WriteLine(data.Tables[i].TableName.ToString()); } listSheetNames.Add(sheetnames); ds.Add(data); List <transaksiPkt> pktSheets = loadDataIntoClass(data); collectionTransaksiPkt.Add(pktSheets); Util.closeExcel(); found = true; } catch (Exception err2) { //MessageBox.Show("File " + temp + " tidak ada"); } } if (!found) { //MessageBox.Show("File " + temp + " tidak ada"); } } } lf.Close(); MessageBox.Show("Done"); comboBox1.DataSource = listSheetNames[0]; loadGridView(ds[0]); }
static private void CloseFormInternal() { LoadForm.Close(); LoadForm = null; }