從Excel中讀出匯入sql server

 /**//// <summary>
    /// 從Excel讀取後匯入sql server
    /// </summary>
    public void ReadExcel()
    {
        string sql = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("teachers.xls") + ";Extended Properties=Excel 8.0";
        OleDbConnection cnn = new OleDbConnection(sql);
        cnn.Open();
        OleDbDataAdapter oda = new OleDbDataAdapter("select * from [教師$]", cnn);
        DataSet ds = new DataSet();
        oda.Fill(ds);
        cnn.Close();

        int count = ds.Tables[0].Rows.Count;
        for (int i = 0; i < count; i++)
        {
            Jzgjbxx model = new Jzgjbxx();
            model.JZGID = ds.Tables[0].Rows[i]["JZGID"].ToString();
            model.JZGBM = ds.Tables[0].Rows[i]["JZGBM"].ToString();
            model.XXID = ds.Tables[0].Rows[i]["XXID"].ToString();
            model.XM = ds.Tables[0].Rows[i]["XM"].ToString();
            model.YHID = ds.Tables[0].Rows[i]["YHID"].ToString();
            model.SFZH = ds.Tables[0].Rows[i]["SFZH"].ToString();
            if (ds.Tables[0].Rows[i]["CSRQ"].ToString() != "")
            {
                model.CSRQ = DateTime.Parse(ds.Tables[0].Rows[i]["CSRQ"].ToString());
            }
            else
            {
                model.CSRQ = DateTime.Now;
            }
            model.XBBM = ds.Tables[0].Rows[i]["XBBM"].ToString();
            model.MZBM = ds.Tables[0].Rows[i]["MZBM"].ToString();
            model.WHCDBM = ds.Tables[0].Rows[i]["WHCDBM"].ToString();
            model.ZCBM = ds.Tables[0].Rows[i]["ZCBM"].ToString();
            model.JSZGBM = ds.Tables[0].Rows[i]["JSZGBM"].ToString();
            model.DYXLBM = ds.Tables[0].Rows[i]["DYXLBM"].ToString();

            model.ZZMMBM = ds.Tables[0].Rows[i]["ZZMMBM"].ToString();
            model.BZLBBM = ds.Tables[0].Rows[i]["BZLBBM"].ToString();
            model.RKZKBM = ds.Tables[0].Rows[i]["RKZKBM"].ToString();
            model.GWZYBM = ds.Tables[0].Rows[i]["GWZYBM"].ToString();
            model.DZXX = ds.Tables[0].Rows[i]["DZXX"].ToString();
            model.BZ = ds.Tables[0].Rows[i]["BZ"].ToString();
            model.SCBZ = ds.Tables[0].Rows[i]["SCBZ"].ToString();
            if (ds.Tables[0].Rows[i]["CJNY"].ToString() != "")
            {
                model.CJRQ = DateTime.Parse(ds.Tables[0].Rows[i]["CJNY"].ToString());
            }
            else
            {
                model.CJRQ = DateTime.Now;
            }
            if (ds.Tables[0].Rows[i]["CJGZNY"].ToString() != "")
            {
                model.CJGZRQ = DateTime.Parse(ds.Tables[0].Rows[i]["CJGZNY"].ToString());
            }
            else
            {
                model.CJGZRQ = DateTime.Now;
            }
            if (ds.Tables[0].Rows[i]["LXNY"].ToString() != "")
            {
                model.LBXGZRQ = DateTime.Parse(ds.Tables[0].Rows[i]["LXNY"].ToString());
            }
            else
            {
                model.LBXGZRQ = DateTime.Now;
            }
            (new JzgjbxxBLL()).Create(model);
        }
        ds.Clear();
    }