Click here to Skip to main content
15,915,172 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
using (SqlBulkCopy bulkCopy =
                             new SqlBulkCopy(sqlConnectionString))
                  {
                      bulkCopy.DestinationTableName = "CDR";
                      bulkCopy.ColumnMappings.Add("RecordFileName", "RecordFileName");
                      bulkCopy.ColumnMappings.Add("Type-of-Recording", "TypeOfRecording");
                      bulkCopy.ColumnMappings.Add("ANumber", "ANumber");
                      bulkCopy.ColumnMappings.Add("BNumber", "BNumber");
                      bulkCopy.ColumnMappings.Add("BNumber-Type", "BNumberType");
                      bulkCopy.ColumnMappings.Add("Who-Pay", "WhoPay");
                      bulkCopy.ColumnMappings.Add("Call-Start-Date", "CallStartDate");
                      bulkCopy.ColumnMappings.Add("Call-Start-Time", "CallStartTime");
                      bulkCopy.ColumnMappings.Add("Call-Duration", "CallDuration");
                      bulkCopy.ColumnMappings.Add("Sample-Type", "SampleType");
                      bulkCopy.ColumnMappings.Add("Outgoing-Route", "OutgoingTrunk");
                      bulkCopy.ColumnMappings.Add("Incoming-Route", "IncommingTrunk");
                      bulkCopy.ColumnMappings.Add("Counter-Number", "CounterNumber");
                      bulkCopy.ColumnMappings.Add("Number-of-Pulse", "NumberofPulse");
                      bulkCopy.ColumnMappings.Add("Cause", "Cause");
                      bulkCopy.ColumnMappings.Add("Location", "Location");
                      bulkCopy.ColumnMappings.Add("Called-Party-Portability-Info", "CalledPartyPortabilityInfo");
                      bulkCopy.ColumnMappings.Add("Call-Reference", "CallReference");
                      bulkCopy.ColumnMappings.Add("Sequence-Number", "SequenceNumber");
                      bulkCopy.ColumnMappings.Add("Network-Call-Reference", "NetworkCallReference");
                      try
                      {
                          bulkCopy.WriteToServer(dr);
                      }
                      catch (Exception ex)
                      {
                          Console.WriteLine(ex.Message);
                      }
                      finally
                      {
                          dr.Close();
                      }


What I have tried:

How can I convert SQLbulkcopy.Columnmappings.Add into int before insert into SQL table?
Posted
Updated 15-May-18 14:30pm
Comments
Rick York 16-May-18 10:57am    
If you are asking about C# code then you should use the C# tag - not a C tag.

1 solution

Why don't you change your column type to double, then do the insert, then change it to int?
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900