将Excel(.xlsx)中的数据导入到数据库中

        string connStr = "Provider=Microsoft.ACE.OLEDB.12.0;Extended Properties='Excel 12.0;HDR=YES;IMEX=1';Data Source=shengshi.xlsx";//文件放到哪里，调试时可以看出。

        private bool InsertCity()
        {
            try
            {
                OleDbDataAdapter dr = new OleDbDataAdapter("select * from [InfoCity$]", connStr);
                DataSet dt = new DataSet();
                dr.Fill(dt);
                dr.Dispose();

                for (int i = 0; i < dt.Tables[0].Rows.Count; i++)
                {
                    string testSql = string.Format("insert into city(provinceId,cityId,cityName) values('{0}','{1}','{2}')", dt.Tables[0].Rows[i]["provinceId"].ToString(), dt.Tables[0].Rows[i]["cityId"].ToString(), dt.Tables[0].Rows[i]["cityName"].ToString());
                   ServiceManager.UserBuyCarService.InsertCity(testSql);
                }
            }
            catch (Exception ex)
            {
                throw new QiPeiException(ex.Message);
            }
            return false;
        }

 

转载于:https://www.cnblogs.com/juancreate2014/p/4425229.html