把excel 数据导入数据库

//把excel 数据导入DataTable中

string conStr=@" Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source = "+fileAddress+";Password=;User ID=Admin;Extended Properties=Excel 8.0" ;

   string cmdText="select * from [Sheet1$]";

   OleDbDataAdapter da = new OleDbDataAdapter(cmdText,conStr);

   DataSet ds = new DataSet();

   da.Fill(ds);
   dt = ds.Tables[0].Copy();

//把DataTable中的数据导入数据库
private void InputTaskInfo(int rowId)
  {
   ITASK_INFOService task_infoService = ServiceLocator.GetService(typeof   (ITASK_INFOService)) as ITASK_INFOService;
   TbTASK_INFO o=new TbTASK_INFO();

   System.DateTime SDate = Convert.ToDateTime(Convert.ToDateTime(this.dt.Rows[rowId][3].ToString()).ToShortDateString());

   //Excel 必须要的字段 --------begin
   o.TASK_ID     = task_infoService.generate_task_id(SDate);   o.STATION     =     this.dt.Rows[rowId][1].ToString();
   o.DEVICE_NAME = this.dt.Rows[rowId][2].ToString();
   o.START_DATE  = SDate;
   o.END_DATE    = Convert.ToDateTime(Convert.ToDateTime(this.dt.Rows[rowId] [4].ToString()).ToShortDateString());
   o.TASK_TIME   = this.dt.Rows[rowId][5].ToString();
   o.JOB_GUT     = this.dt.Rows[rowId][6].ToString();
   o.STOP_STATUS = this.dt.Rows[rowId][7].ToString();
   o.REMARK      = this.dt.Rows[rowId][8].ToString();
   //Excel 必须要的字段 --------end

   o.APPLY_MAN   =  AppContext.EmpName;//用登陆用户(姓名)
   o.EXE_STATUS  = "";
   o.PROJ_ID     = "";
   o.APPROVE_MAN = "";
   o.APPLY_DATE  = System.DateTime.Now.Date;
   o.APPROVE_DATE=DateTime.Now.Date;  //need get rid of
   o.TASK_SOURCE = "99"; //任务来源 :其它
   o.APPROVE_STATUS="10"; 
   o.EXE_STATUS = "正常";   
   object valueList=task_infoService.insert_task_info(o);
  }