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());
}
}
}