大量数据插入到sqlserver数据库

 Stopwatch sw = new Stopwatch();
            DataTable dt = GetTableSchema();
            using (SqlConnection conn = new SqlConnection(StrConnMsg))
            {
                SqlBulkCopy bulkCopy = new SqlBulkCopy(conn);
                bulkCopy.DestinationTableName = "T_SJCJ";
                bulkCopy.BatchSize = dt.Rows.Count;
                conn.Open();
                sw.Start();

                for (int i = 0; i < nvalue.Length; i++)
                {
                    DataRow dr = dt.NewRow();
                    dr[0] = Guid.NewGuid();
                    dr[1] = string.Format("通道1", i);
                    dr[2] = (decimal)nvalue[i];
                    dr[3] = string.Format("通道2", i);
                    dr[4] = (decimal)nvalue1[i];
                    dr[5] = Index[i];
                    dr[6] = (decimal)dnumNC[i];
                    dr[7] = strt[i]; 
                    dt.Rows.Add(dr);
                }
                if (dt != null && dt.Rows.Count != 0)
                {
                    bulkCopy.WriteToServer(dt);
                    sw.Stop();
                }

            }

            Array.Clear(nvalue, 0, nvalue.Length);//可写可不写
            Array.Clear(nvalue1, 0, nvalue1.Length);//可写可不写
            Array.Clear(Index, 0, Index.Length);//可写可不写
          
            dGV df = new dGV();
            df.Show();


  static DataTable GetTableSchema()
        {
            DataTable dt = new DataTable();
            dt.Columns.AddRange(new DataColumn[] {   
        new DataColumn("Id",typeof(Guid)),  
        new DataColumn("T_TdName0",typeof(string)),  
        new DataColumn("T_Value0",typeof(decimal)),
            new DataColumn("T_TdName1",typeof(string)),  
        new DataColumn("T_Value1",typeof(decimal)),
         new DataColumn("T_Index",typeof(int)),
            new DataColumn("T_numNC",typeof(decimal)),
             new DataColumn("T_dtime",typeof(string))});
            return dt;
        }