private void btnLoad_Click(object sender, EventArgs e)
{
//MessageBox.Show(Util.TaskInfo.TaskSetting.InputFilePath);
ExlAddin.Read2Dt dt = new ExlAddin.Read2Dt();
dt.FilePrepare();
dtForm = dt.Exl2Dt();
dataGridView1.DataSource = dtForm;
//MessageBox.Show(test.symType);
//Console.WriteLine(dataGridView1.Left.ToString());
// filter SymbolType to Listbox to select
var query = from c in dtForm.AsEnumerable()
group c by c.Field<string>("SymbolType");
foreach (var item in query)
{
if (item.Key == null)
continue;
//Console.WriteLine(item.Key);
listBoxSymbol.Items.Add(item.Key);
}
}
private void btnLoad_Click(object sender, EventArgs e)
{
//MessageBox.Show(Util.TaskInfo.TaskSetting.InputFilePath);
ExlAddin.Read2Dt dt = new ExlAddin.Read2Dt();
dt.FilePrepare();
dtForm = dt.Exl2Dt();
dataGridView1.DataSource = dtForm;
//MessageBox.Show(test.symType);
//Console.WriteLine(dataGridView1.Left.ToString());
// filter SymbolType to Listbox to select
var query = from c in dtForm.AsEnumerable()
group c by c.Field <string>("SymbolType");
foreach (var item in query)
{
if (item.Key == null)
{
continue;
}
//Console.WriteLine(item.Key);
listBoxSymbol.Items.Add(item.Key);
}
}
