class Program

    {

        /// <summary>

        /// 批量插入

        /// </summary>

        /// <param name="dt">数据集</param>

        public static void BulkToDB(DataTable dt)

        {

            using (SqlConnection sqlConn = new SqlConnection("Data Source=.;uid=sa;pwd=123456;Initial Catalog=Test"))

            {

                SqlBulkCopy bulkCopy = new SqlBulkCopy(sqlConn);

                bulkCopy.DestinationTableName = "UserInfo";  //要插入数据的表名

                bulkCopy.BatchSize = dt.Rows.Count;          //插入的条数

                try

                {

                    sqlConn.Open();

                    if (dt != null && dt.Rows.Count != )

                        bulkCopy.WriteToServer(dt);

                }

                catch (Exception ex)

                {

                    throw ex;

                }

                finally

                {

                    sqlConn.Close();

                    if (bulkCopy != null)

                        bulkCopy.Close();

                }

            }

        }

        /// <summary>

        /// 创建表结构,（Id（自增）,LoginName，LoginPwd）

        /// </summary>

        /// <returns></returns>

        public static DataTable GetTableSchema()

        {

            DataTable dt = new DataTable();

            dt.Columns.AddRange(new DataColumn[]{

                new DataColumn("Id",typeof(int)),

                new DataColumn("LoginName",typeof(string)),

                new DataColumn("LoginPwd",typeof(string))

            });

            return dt;

        }

        static void Main(string[] args)

        {

            //100万条数据

            Stopwatch sw = new Stopwatch();

            for (int multiply = ; multiply < ; multiply++)

            {

                DataTable dt = GetTableSchema();

                for (int count = multiply * ; count < (multiply + ) * ; count++)

                {

                    DataRow r = dt.NewRow();

                   // r[0] = 1;//因为该列是自增列，所以可以不赋值

                    r[] = string.Format("Name-{0}", count * multiply);

                    r[] = string.Format("Pwd-{0}", count * multiply);

                    dt.Rows.Add(r);

                }

                sw.Start();

                BulkToDB(dt);

                sw.Stop();

                Console.WriteLine(string.Format("Elapsed Time is {0} Milliseconds", sw.ElapsedMilliseconds));

            }

            Console.ReadLine();

        }

    }