public void ImportData(string sPath, string ApplyNo) { string dicPath = sPath + ApplyNo; if (Directory.Exists(dicPath)) { string[] files = Directory.GetFiles(dicPath); if (files.Length > 0) { DataTable dt = ReadFile(files[0]); string connStr = System.Configuration.ConfigurationManager.ConnectionStrings["ctpconn"].ConnectionString; BatchImportUtil import = new BatchImportUtil(connStr); import.DoBatchImport(dt, "Track_Retrospect_JawasoftCode", null, System.Data.SqlClient.SqlBulkCopyOptions.Default); } } }
public void ImportTableValued(string sPath, string ApplyNo) { string dicPath = sPath + ApplyNo; if (Directory.Exists(dicPath)) { string[] files = Directory.GetFiles(dicPath); if (files.Length > 0) { DataTable dt = ReadFile2(files[0]); string connStr = System.Configuration.ConfigurationManager.ConnectionStrings["ctpconn"].ConnectionString; BatchImportUtil import = new BatchImportUtil(connStr); SqlParameter[] param = new SqlParameter[1]; SqlParameter p = new SqlParameter("@TV", SqlDbType.Structured); p.Value = dt; p.TypeName = "dbo.JCodeTableValued"; param[0] = p; import.BulkTableValuedToDB("SP_BatchJCodeByTableValued", param); } } }