摘要: 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... 阅读全文
posted @ 2013-03-13 18:45 Keep Balance 阅读(213) 评论(0) 推荐(0) 编辑
摘要: 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... 阅读全文
posted @ 2013-01-28 18:48 Keep Balance 阅读(169) 评论(0) 推荐(0) 编辑