如何在WPF中插入SQL数据库中读取Excel数据 [英] How to read Excel data in insert into SQL database in WPF

问题描述

我正在使用fileUpload上传Excel文件，上传后我想将所有数据插入WPF中的SQL数据库或数据集中.

我的文件上传代码..

私有无效btnBrowse_Click(对象发送者，RoutedEventArgs e)
{
OpenFileDialog ofd = new OpenFileDialog();
ofd.Multiselect = false;
ofd.Filter ="AllFiles | *.*";

如果((bool)ofd.ShowDialog()== true)
{
字符串FileName = ofd.FileName;
txtFileName.Text = FileName;
}
}

因此，请帮助我如何从WPF应用程序中的Excel文件中将数据插入SQL数据库或DataSet或DataTable中....

解决方案

您可以起诉以下代码以导出excel到wpf中的数据表:

 命名空间 dataexport

{
    ///  <  > 
 ///  MainWindow.xaml的交互逻辑
 ///  <  /summary  > 
 公共 部分 类 MainWindow : 窗户
    {
        公共 MainWindow()
        {
            InitializeComponent();
        }

        私有 无效 button1_Click(对象发​​件人，RoutedEventArgs e)
        {
          Workbook workbook = 新 Workbook();
          workbook.LoadFromFile( @" ，ExcelVersion.Version97to2003)；
          工作表工作表= workbook.Worksheets [ 0 ];
          DataTable dataTable = sheet.ExportDataTable();
          DataView视图= 新 DataView(dataTable);
          此 .dataGrid1.ItemsSource =视图；
          此 .dataGrid1.AutoGenerateColumns =  true ;
        }
    }
} 

但您必须下载 .net excel [
if ((bool) ofd.ShowDialog()==true)
{
string FileName = ofd.FileName;
txtFileName.Text = FileName;
}
}

So please help me how to insert data in SQL database or DataSet or DataTable from Excel file in WPF Application....

解决方案

You can sue below code to export excel to datatable in wpf:

namespace dataexport

{
    /// <summary>
    /// Interaction logic for MainWindow.xaml
    /// </summary>
    public partial class MainWindow : Window
    {
        public MainWindow()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, RoutedEventArgs e)
        {
          Workbook workbook = new Workbook();
          workbook.LoadFromFile(@"D:\dataexport.xls", ExcelVersion.Version97to2003);  
          Worksheet sheet = workbook.Worksheets[0];
          DataTable dataTable = sheet.ExportDataTable();
          DataView view = new DataView(dataTable);
          this.dataGrid1.ItemsSource = view;
          this.dataGrid1.AutoGenerateColumns = true;
        }
    }
}

but you have to download a .net excel[^]component.Hope it works.

这篇关于如何在WPF中插入SQL数据库中读取Excel数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！