excel导入数据到sqlserver

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了excel导入数据到sqlserver，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含2731字，纯文字阅读大概需要4分钟。

内容图文

static System.Data.DataSet ExcelSqlConnection(string filepath, string tableName) { string strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filepath + ";Extended Properties=‘Excel 8.0;HDR=YES;IMEX=1‘"; OleDbConnection ExcelConn = new OleDbConnection(strCon); try { string strCom = string.Format("SELECT * FROM [Sheet1$]"); ExcelConn.Open(); OleDbDataAdapter myCommand = new OleDbDataAdapter(strCom, ExcelConn); DataSet ds = new DataSet(); myCommand.Fill(ds, "[" + tableName + "$]"); ExcelConn.Close(); return ds; } catch { ExcelConn.Close(); return null; } }

2、将数据写入到数据库

 protected void Button2_Click(object sender, EventArgs e)
    {
        string filename = FileUpload1.FileName;
        string savePath = Server.MapPath(("~/fujian/") + filename);
        FileUpload1.SaveAs(savePath);
        DataSet ds = ExcelSqlConnection(savePath, filename);
        //GridView1.DataSource = ds;
        //GridView1.DataBind();
        DataRow[] dr = ds.Tables[0].Select();
        for (int i = 0; i < dr.Length; i++)
        {
            SqlConnection myconn = myconnect();
            myconn.Open();
            
            string title = dr[i]["名称"].ToString();
            string huanxianweizhi = dr[i]["环线位置"].ToString();
            string quyu = dr[i]["区域"].ToString();
            string sqlstr1 = "select * from dbo.test where name=‘" + quyu + "‘";    //区域中间表转换
            SqlCommand myCmd1 = new SqlCommand(sqlstr1, myconn);
            SqlDataAdapter mydata = new SqlDataAdapter(myCmd1);
            DataSet my = new DataSet();
            mydata.Fill(my);
            GridView1.DataSource = my;
            GridView1.DataBind();
            string quyu1 = my.Tables[0].Rows[0][0].ToString(); ;
            //SqlDataAdapter adapt = new SqlDataAdapter(sqlstr1, myconn);
            DataSet ds1 = new DataSet();
            string zuoluo = dr[i]["座落"].ToString();
            string yongtu = dr[i]["用途"].ToString();
            string chengjiaotaoshu = dr[i]["成交套数"].ToString();
            string jianzhumianji = dr[i]["建筑面积"].ToString();
            string chengjiaozongjia = dr[i]["成交总价"].ToString();
            string dangrijunjia = dr[i]["当日均价"].ToString();
            string chengjiaoriqi = dr[i]["成交日期"].ToString();
            string qitashuoming = dr[i]["其他说明"].ToString();
            string bankuai = dr[i]["板块"].ToString();
            //SqlConnection myconn = myconnect();
            //myconn.Open();
            string sqlstr = "insert into dbo.youweishuju(名称,环线位置,区域,座落,用途,成交套数,建筑面积,成交总价,当日均价,成交日期,其他说明,板块)values(‘" + title + "‘,‘" + huanxianweizhi + "‘,‘" + quyu1 + "‘,‘" + zuoluo + "‘,‘" + yongtu + "‘,‘" + chengjiaotaoshu + "‘,‘"+ jianzhumianji +"‘,‘"+ chengjiaozongjia +"‘,‘"+ dangrijunjia +"‘,‘"+ chengjiaoriqi +"‘,‘"+ qitashuoming +"‘,‘"+ bankuai +"‘)";
            //string sqlstr = "insert into dbo.youweishuju(名称)values(‘" + title + "‘)";
            SqlCommand myCmd = new SqlCommand(sqlstr, myconn);
            myCmd.ExecuteNonQuery();
            myconn.Close();
        }
    }

 

excel导入数据到sqlserver

标签：

本文系统来源：http://www.cnblogs.com/lovejunjuan/p/4683232.html

内容总结

以上是互联网集市为您收集整理的excel导入数据到sqlserver全部内容，希望文章能够帮你解决excel导入数据到sqlserver所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端

---