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