private void btnPreview_Click(object sender, EventArgs e)
{
try
{
StreamReader sr = new StreamReader(txtPath.Text);
DataTable dt = sr.ConvertCSVtoDataTable();
if (dt.IsEmpty() == false)
{
DataSet ds = new DataSet();
ds.Tables.Add(dt);
DataPreview dp = new DataPreview(ds);
dp.ShowDialog();
}
}
catch (Exception ex)
{
ex.Write();
}
}
private void cmbIdentifier_DropDown(object sender, EventArgs e)
{
try
{
StreamReader sr = new StreamReader(txtPath.Text);
DataTable dt = sr.ConvertCSVtoDataTable();
if (dt.IsEmpty() == false)
{
ComboBox ctrl = (ComboBox)sender;
ctrl.Items.Clear();
foreach (DataColumn dc in dt.Columns)
{
ctrl.Items.Add(dc.ColumnName.Replace("\"", String.Empty));
}
}
}
catch (Exception ex)
{
ex.Write();
}
}