C#导入XLS数据到数据库
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");
}
}
}
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");
}
}
}
作者:Cat Qi
出处:http://qixuejia.cnblogs.com/
本文版权归作者和博客园共有,欢迎转载,但未经作者同意必须保留此段声明,且在文章页面明显位置给出原文连接,否则保留追究法律责任的权利。
出处:http://qixuejia.cnblogs.com/
本文版权归作者和博客园共有,欢迎转载,但未经作者同意必须保留此段声明,且在文章页面明显位置给出原文连接,否则保留追究法律责任的权利。