将DataTable保存到数据库的数据表中

最新推荐文章于 2023-05-22 21:47:07 发布

weixin_30628801

最新推荐文章于 2023-05-22 21:47:07 发布

阅读量433

点赞数

文章标签：数据库 c# javascript ViewUI

原文链接：http://www.cnblogs.com/Dlonghow/archive/2011/11/12/2246128.html

版权

本文介绍了一种从Excel文件中读取数据并将其批量导入到SQL Server数据库的方法。使用OleDb连接Excel文件，通过SqlBulkCopy实现高效的数据迁移。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1     static void Main( string[] args)
2         {
3             DataTable _data = new DataTable();
4             OleDbConnection dbConnection = new OleDbConnection( @" Provider=Microsoft.Jet.OLEDB.4.0; " + @" Data Source=D:\My Work\Pawn Shop\Jewelry DB.xls; " + @" Extended Properties=""Excel 8.0;HDR=Yes;"" ");
5             dbConnection.Open();
6
7              // List<string> _Fields = new List<string>()
8              // {
9              //     "ID","Date","Time","Last Name","First Name","DOB","Street","Town","State","Zip","DL/Passport #","Phone #","Items Sold","Photo Link","Suspicious","Associates","Notes","Store","Receipt #","Price"
10              // };
11
12              try
13             {
14                 OleDbDataAdapter dbAdapter = new OleDbDataAdapter( " SELECT * FROM [Sheet3$] ", dbConnection);
15                 dbAdapter.Fill(_data);
16                  if (_data != null && _data.Rows.Count > 0)
17                 {
18                     SqlBulkCopy bcp = new SqlBulkCopy( " server=10.1.1.33;database=PawnShop_DTS_20110712;uid=sa;pwd=infoshare ");
19                     bcp.DestinationTableName = " pawn_sale_2 ";
20                     bcp.WriteToServer(_data);
21                 }
22             }
23              finally
24             {
25                 dbConnection.Close();
26             }
27         }

转载于:https://www.cnblogs.com/Dlonghow/archive/2011/11/12/2246128.html