数据源中String类型的给定值无法转换为指定目标列的bigint类型

那是我的代码：

protected void SendToServer_Click(object sender, EventArgs e) { DataTable Values = Session["valuesdt"] as DataTable; if (Values.Rows.Count > 0) { //Fix up default values for (int i = 0; i < Values.Rows.Count; i++) { Values.Rows[i]["Mobile1"] = Values.Rows[i]["Mobile1"].ToString() == "" ? 0 : double.Parse(Values.Rows[i]["Mobile1"].ToString()); Values.Rows[i]["Mobile2"] = Values.Rows[i]["Mobile2"].ToString() == "" ? 0 : double.Parse(Values.Rows[i]["Mobile2"].ToString()); Values.Rows[i]["Tel"] = Values.Rows[i]["Tel"].ToString() == "" ? 0 : double.Parse(Values.Rows[i]["Tel"].ToString()); Values.Rows[i]["Category"] = Values.Rows[i]["Category"].ToString(); } DataTable dv = Values.DefaultView.ToTable(true, "Mobile1", "Mobile2", "Tel", "Category"); BulckCopyDataTable(dv, "client", 1000); } } public void BulckCopyDataTable(DataTable dt,string DestinationTable,int batchSize) { connection.Open(); using (SqlBulkCopy copy = new SqlBulkCopy(connection)) { copy.BatchSize = batchSize; copy.DestinationTableName = DestinationTable; copy.WriteToServer(dt); connection.Close(); } } 

我不知道为什么这个错误被抛出在数据库中：

 Mobile1 bigint, Mobile2 bigint, Tel bigint, Category nvarchar(MAX) 

 bulkCopy.ColumnMappings.Add(new SqlBulkCopyColumnMapping(0, 1)); bulkCopy.ColumnMappings.Add(new SqlBulkCopyColumnMapping(1, 2)); bulkCopy.ColumnMappings.Add(new SqlBulkCopyColumnMapping(2, 3)); bulkCopy.ColumnMappings.Add(new SqlBulkCopyColumnMapping(3, 6)); //look here, index is different bulkCopy.ColumnMappings.Add(new SqlBulkCopyColumnMapping(4, 8)); //and again bulkCopy.ColumnMappings.Add(new SqlBulkCopyColumnMapping(5, 9));