excel数据导入到sqlserver中---------工作笔记

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using JuMi.BLL.Business;
using System.Data;
using System.Data.OleDb;
using System.Windows.Forms;

using JuMi.Model.Business;
using JuMi.BLL.Business;

namespace JuMi.Web.Form.Manager.Business
{
    public partial class WebForm1 : JuMi.Web.UI.BasePage
    {
        protected void Page_Load(object sender, EventArgs e)
        {


        }
        /// <summary>
        /// 导入广告商信息
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void btnAdverInfo_Click(object sender, EventArgs e)
        {
            DataTable dt = ExcelDemo.GetExcelToDatatable("F:\Demo\excelDemo.xlsx", "table");
            int count = 0;
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                Model_Advertiser model = new Model_Advertiser();
                model.Adver_CompanyName = dt.Rows[i][0].ToString();//名称
                model.Adver_Distinguish = dt.Rows[i][1].ToString();//税号
                model.Adver_RegisPhone = dt.Rows[i][2].ToString();//电话
                model.Adver_BankNumber = dt.Rows[i][3].ToString();//银行账号
                model.Adver_BankAddress = dt.Rows[i][4].ToString();//开户行地址
                model.Adver_RegisAdress = dt.Rows[i][5].ToString();//注册地址
                model.Adver_State = 0;
                if (AdvertiserBLL.Add(model) > 0)
                {
                    count++;
                }
            }
            if (count >= dt.Rows.Count)
            {
                JscriptMsgSuccess("广告商信息导入成功！", "", "function(){api.reload();}");
            }
            else
            {
                JscriptMsgError("广告商信息导入失败！", "", "function(){api.reload();}");
            }
        }

    }
}
using System;
using System.Collecti