CSV文件导入数据库

 #region 读取Csv文件返回DataSet


        /// <summary>


        /// 读取Csv文件返回DataSet


        /// </summary>


        /// <returns>Csv内容</returns>


        public DataSet Csv()
        {




            string FilePath = @"C:\Users\GuoQiang\Desktop";


            string FileName = "myDataLogger.csv";




            OleDbConnection OleCon = new OleDbConnection();
            OleDbCommand OleCmd = new OleDbCommand();
            OleDbDataAdapter OleDa = new OleDbDataAdapter();
            DataSet CsvData = new DataSet();


            OleCon.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + FilePath + ";Extended Properties='Text;FMT=Delimited;HDR=YES;'"; ;
            //OleCon.ConnectionString = " 'Microsoft.Jet.OLEDB.4.0 ','Provider=SQLOLEDB', 'Extended   Properties=text;HDR=Yes;FMT=Delimited ', 'Data   Source=E:\\数据抓取\\入库\\"; 
            OleCon.Open();


            OleCmd.Connection = OleCon;


            OleCmd.CommandText = "select * From " + FileName;


            OleDa.SelectCommand = OleCmd;


            try
            {


                OleDa.Fill(CsvData, "Csv");


                return CsvData;


            }


            catch
            {


                return CsvData;


            }


            finally
            {


                OleCon.Close();


                OleCmd.Dispose();


                OleDa.Dispose();


                OleCon.Dispose();


            }


        }


        #endregion
//写入数据库源代码；此方法是源文件内容中的例必须和要导入的表的例数一至，且数据格式一至
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.Sql;
using System.Data.SqlClient;
namespace lyzApplication2009
{
    /// <summary>
    /// 将数据写入数据库表中去
    /// </summary>
    class SqlBulkData
    {
        SqlConnection SqlCon = new SqlConnection();
        #region 将数据写数据库表中去（大容量）例与数据库表例一至
        /// <summary>
        /// 将数据写数据库表中去（大容量）例与数据库表例一至
        /// </summary>
        /// <param name="_Ds">数据源内容</param>
        /// <param name="_TableName">表名</param>
        /// <returns>返回是否成功！</returns>
        public bool BulkData(DataSet _Ds,string _TableName)
        {
            SqlCon.ConnectionString = PublicClass.ConnectString;
            SqlCon.Open();
            SqlBulkCopy SqlBulk = new SqlBulkCopy(SqlCon);
            SqlBulk.DestinationTableName = _TableName;
            try
            {
                SqlBulk.WriteToServer(_Ds.Tables[0], DataRowState.Unchanged);
                return true;
            }
            catch
            {
                return false;
            }
            finally
            {
                SqlCon.Close();
                SqlCon.Dispose();
                SqlBulk.Close();
            }
        }
        #endregion
    }
}