private void Import() { if (txtFileName.Text.Trim() != string.Empty) { try { string[] strTables = GetTableExcel(txtFileName.Text); frmSelectTables objSelectTable = new frmSelectTables(strTables); objSelectTable.ShowDialog(this); objSelectTable.Dispose(); if ((SelectedTable != string.Empty) && (SelectedTable != null)) { DataTable dt = GetDataTableExcel(txtFileName.Text, SelectedTable); dataGridView1.DataSource = dt.DefaultView; } } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } } }
private void Import() { if (mSelectedFile.Trim() != string.Empty) { try { string[] strTables = GetTableExcel(mSelectedFile); frmSelectTables objSelectTable = new frmSelectTables(strTables); objSelectTable.ShowDialog(this); objSelectTable.Dispose(); if ((SelectedTable != string.Empty) && (SelectedTable != null)) { DataTable dt = GetDataTableExcel(mSelectedFile, SelectedTable); dt.Columns.Add(new DataColumn(Properties.Resources.DeliverCase, typeof(string))); dataGridView1.DataSource = dt.DefaultView; } } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } } }