C#导入XLS数据到数据库
Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->using System; using System.Collections; using System.Configuration; using System.Data; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using Food.BLL; using Food.Models; using Food.DAL; public partial class test_ImportXls : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { ImportData(); } private DataSet xsldata(string filepath) { string strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filepath + ";Extended Properties=‘Excel 8.0;IMEX=1‘"; System.Data.OleDb.OleDbConnection Conn = new System.Data.OleDb.OleDbConnection(strCon); string strCom = "SELECT * FROM [Sheet1$]"; Conn.Open(); System.Data.OleDb.OleDbDataAdapter myCommand = new System.Data.OleDb.OleDbDataAdapter(strCom, Conn); DataSet ds = new DataSet(); myCommand.Fill(ds, "[Sheet1$]"); Conn.Close(); return ds; } private void ImportData() { //批量添加 try { string fileurl = @"C:\Documents and Settings\Administrator\桌面\InsideLink.xls"; DataSet ds = new DataSet();//取得数据集 ds = xsldata(fileurl); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { string typename = ds.Tables[0].Rows[i]["类名"].ToString(); if (typename.Length > 0) { string linkvalue = ds.Tables[0].Rows[i]["链接"].ToString(); DBHelper.ExecuteCommand("Insert Into replacekeyword values(‘" + typename + "‘,‘" + linkvalue + "‘,‘‘,‘‘,‘‘,1,1)"); //dbhelper里面包含连接字符串 } else { break; } } Response.Write("OK"); } catch (Exception err) { Response.Write("Error"); } } }
郑重声明:本站内容如果来自互联网及其他传播媒体,其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享,并不代表本站赞同其观点和对其真实性负责,也不构成任何其他建议。