摘要:
using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Data;namespace ConsoleApplication2{ class Program { static void Main(string[] args) { DataTable dt = AddUserInfo(); IEnumerable<UserInfo> i = GetUserInfoByYield(dt... 阅读全文
摘要:
Problem: when using Excel Source task to load excel data into database, if the data type in one columnis different, it will appears Null into our database. Solution:View Code using Microsoft.Office.Interop.Excel to process excel file public System.Data.DataTable ReadExcel() { Syst... 阅读全文