将DataTable保存到数据库的数据表中代码,CSharp代码库,德仔网

代码语言

代码分类

【CSharp】将DataTable保存到数据库的数据表中

作者:Dezai.CN / 发布于2012/3/20/ 557

<div>static void Main(string[] args)
 {
 DataTable _data = new DataTable();
 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;""");
 dbConnection.Open();

 //List<string> _Fields = new List<string>()
 //{
 // "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"
 //};

 try
 {
 OleDbDataAdapter dbAdapter = new OleDbDataAdapter("SELECT * FROM [Sheet3$]", dbConnection);
 dbAdapter.Fill(_data);
 if (_data != null && _data.Rows.Count > 0)
 {
 SqlBulkCopy bcp = new SqlBulkCopy("server=10.1.1.33;database=PawnShop_DTS_20110712;uid=sa;pwd=infoshare");
 bcp.DestinationTableName = "pawn_sale_2";
 bcp.WriteToServer(_data);
 }
 }
 finally
 {
 dbConnection.Close();
 }
 }

试试其它关键字

　ataTable　

同语言下

可能有用的

Dezai.CN贡献的其它代码(4037)