private void BtnExport_Click(object sender, EventArgs e)
{
//打开文件对话框
System.Windows.Forms.OpenFileDialog fd = new System.Windows.Forms.OpenFileDialog
{
//过滤exl文件
Filter = @"Excel文件 (*.xls; *.xlsx)|*.xls; *.xlsx|All Files (*.*)|*.*"
};
if (fd.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
string fileName = fd.FileName;//文件名
try
{
// Excel --> DataTable
_Data = new DataTable();
_Data = CommonSQL.GetExcelData(fileName);
if (CommonSQL.IsNoData(_Data))
{
Notice.Show("空数据！", "错误", 3, Panuon.UI.Silver.MessageBoxIcon.Error);
}
// 清空数据
DGloc.ItemsSource = null;
// 获取数据
DGloc.ItemsSource = _Data.DefaultView;
// 保存按钮
BtnInsertDB.IsEnabled = true;
}
catch (Exception ex)
{
Notice.Show(ex.Message, "错误", 3, Panuon.UI.Silver.MessageBoxIcon.Error);
}
}
}
