[转载]C#导入XLS数据到数据库

[转载]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");
        }
    }
}
[转载]C#导入XLS数据到数据库

[转载]C#导入XLS数据到数据库,布布扣,bubuko.com

[转载]C#导入XLS数据到数据库

上一篇:MS SQL Server存储过程


下一篇:简易SQL Server Business Intelligence数据挖掘教程