C#讀取Visual FoxPro（*.dbf）數據并使用SqlBulkCopy插入到SqlServer 2008 R2數據表中

2019-11-17 02:03:53

字體：大中小

來源：轉載

供稿：網友

C#讀取Visual FoxPRo（*.dbf）數據并使用SqlBulkCopy插入到SqlServer 2008 R2數據表中公司數據庫從32位的SqlServer 2005升級到64位的SqlServer 2008 R2后，無法再像原來通過Link Server連接VFP同步數據，因此考慮用代碼程序從VFP數據庫中讀取所需數據然后再插入到SqlServer數據庫中，下面貼出該C#代碼以備忘或供有需要者參考。 privatevoidGetDataFromVFP() {OdbcConnectionconn =null;try {stringstrOdbcConn =@"Driver={Microsoft Visual FoxPro Driver};SourceType=DBF;SourceDB=D:/a/b;Exclusive=No;Collate=Machine;";stringstrInsertConn =@"User id=a;PassWord=b;Database=c;Server=d;Connect Timeout=50;Max Pool size=200;Min pool Size=5"; conn =newOdbcConnection(); conn.ConnectionString = strOdbcConn; conn.Open();stringstrTableName ="";for(inti = -8; i < 0; i++) { strTableName ="FOLIO"+DateTime.Today.AddDays(i).ToString("dd");stringsql =string.Format(@"select a,b,c from {0}", strTableName);OdbcDataAdapterda =newOdbcDataAdapter(sql, conn);DataTabledt =newDataTable(); da.Fill(dt);SqlBulkCopybulkCopy =newSqlBulkCopy(strInsertConn); bulkCopy.BulkCopyTimeout = 1800000; bulkCopy.DestinationTableName ="strTableName"; bulkCopy.WriteToServer(dt); } }catch { }finally {if(conn !=null) { conn.Close(); } } }

上一篇：GPS部標平臺的架構設計(十)-基于Asp.NET MVC構建GPS部標平臺

下一篇：js 操作ASP.NET服務器控件