当前位置:编程学习 > C#/ASP.NET >>

请教各位前辈如何动态增加cp.ColumnMappings.Add(),?

SqlConnection cons = new SqlConnection(tcon);
            try
            {
                cons.Open();
                SqlBulkCopy  cp = new SqlBulkCopy(cons);
               cp.BatchSize = 10;
                cp.BulkCopyTimeout = 60;
                cp.DestinationTableName = tablename;

                cp.ColumnMappings.Add(0, 1);
                cp.ColumnMappings.Add(1, 2);
                cp.ColumnMappings.Add(2, 3);
                  ...................

                cp.WriteToServer(dt);
                cons.Close();
                cons.Dispose();

请教各位前辈如何动态增加cp.ColumnMappings.Add(),?
补充:.NET技术 ,  C#
CopyRight © 2012 站长网 编程知识问答 www.zzzyk.com All Rights Reserved
部份技术文章来自网络,