private void btnProcessData_Click(object sender, EventArgs e)
{
if (cmbSheet.SelectedItem != null)
{
ComboboxItem item = (ComboboxItem)cmbSheet.SelectedItem;
DataTable dt = MyCommonSRV.GetExcelCSVFileData(new FileInfo(txtFilePath.Text), item.Text);
dgvProcess.DataSource = dt.AsDataView();
dgvProcess.Tag = dt.Copy();
}
}
private void btnBrowse_Click(object sender, EventArgs e)
{
if (openFileDialog_.ShowDialog() == DialogResult.OK)
{
txtFilePath.Text = openFileDialog_.FileName;
DataTable dt = MyCommonSRV.GetExcelFileSchemaData(new FileInfo(txtFilePath.Text));
cmbSheet.Items.Clear();
foreach (DataRow dr in dt.Rows)
{
ComboboxItem item = new ComboboxItem();
item.Text = Convert.ToString(dr["TABLE_NAME"]);
item.Value = Convert.ToString(dr["TABLE_NAME"]);
cmbSheet.Items.Add(item);
}
}
}
