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