System.Data.SqlClient.SqlBulkCopy

[小熊写代码]

            using (System.Data.SqlClient.SqlBulkCopy sqlBC = new System.Data.SqlClient.SqlBulkCopy(sqlconnt))
            {
                sqlBC.BatchSize = 100000;
                sqlBC.BulkCopyTimeout = 60;
                sqlBC.DestinationTableName = "FMRS_data";
                for (int i = 0; i < lielist.Length; i++)
                {
                    sqlBC.ColumnMappings.Add(lielist[i], lielist[i]);
                }
                sqlBC.ColumnMappings.Add("ckbh", "ckbh");
                sqlBC.ColumnMappings.Add("ckzh", "ckzh");
                sqlBC.ColumnMappings.Add("cft", "cft");
                sqlBC.ColumnMappings.Add("dp", "dp");
                sqlBC.ColumnMappings.Add("crdt", "crdt");
                sqlBC.WriteToServer(tblDatas);
            }
        }

tblDatas这里有100条数据。导入成功查询就一条就没了。怎么弄就只有一条

[xdashewan]

看着貌似没错，但你代码并不完整，你得自己断点调试下

[exception92]

http://www.cnblogs.com/shikyoh/archive/2011/07/01/2095633.html