Bulk insert 数据库名.用户名.表名

from '数据文件路径'

with

(

formatfile = '格式文件路径',

FirstRow = 2    --指定数据文件中开始的行数，默认是1

)  

BULK INSERT db_mgr.dbo.T_Student

FROM 'C:/student.data'

WITH

(

    FORMATFILE = 'C:/student_fmt.xml'

)  

using (System.Data.SqlClient.SqlBulkCopy sqlBC = new System.Data.SqlClient.SqlBulkCopy(conn))

{ sqlBC.BatchSize = ;

sqlBC.BulkCopyTimeout = ;

sqlBC.DestinationTableName = "dbo.TableB";

sqlBC.ColumnMappings.Add("valueA", "Value1");

sqlBC.WriteToServer(dt);

} 

        public void SqlBulkCopyForDataTable(string tableName, DataTable dt, out string msg)

        {

            msg = "";

            try

            {

                using (SqlConnection conn = (SqlConnection)idataHelper.CreateConnection)

                {

                    conn.Open();

                    using (SqlBulkCopy sqlbulkcopy = new SqlBulkCopy(conn))

                    {

                        try

                        {

                            sqlbulkcopy.DestinationTableName = tableName;

                            sqlbulkcopy.ColumnMappings.Add("Id", "Id列");

                            sqlbulkcopy.ColumnMappings.Add("Name", "名字");

                            sqlbulkcopy.WriteToServer(dt);

                        }

                        catch (System.Exception ex)

                        {

                            msg = ex.ToString();

                            throw ex;

                        }

                        finally

                        {

                            conn.Close();

                        }

                    }

                }

            }

            catch (Exception ex)

            {

                throw ex;

            }

            finally

            {

            }

        }