摘要:
using System;using System.Collections.Generic;using System.Text;using System.EnterpriseServices;using System.Data.SqlClient;namespace myCOM{ [Transaction(TransactionOption.Required)] public class MyComClass : ServicedComponent { public SqlConnection Conn; public SqlConnection Conn1; public void test 阅读全文
摘要:
//Excel导入到数据库(sql/oracle)和Grid/DataTable导出Excel /// <summary> /// 将Excel文件数据批量倒入到数据库—SQL /// </summary> private void BatchUploadSql() { string myString = "provider = microsoft.jet.oledb.4.0; data source = E:/Workaround/TestItem/BatchExcel/test.xls;extended properties=excel 8.0" 阅读全文