如何将double值转换为整数！ ！ ！ [英] How to convert double value to integer! ! !

问题描述

 using（DbDataReader dr = command.ExecuteReader（））
 {
 // SQL Server连接字符串
字符串sqlConnectionString =数据源= ACHRAF \\\ \\ SQLEXPRESS;初始目录= PFEBD;集成安全性=真; 
 
 //批量复制到SQL Server 
使用（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（原因，原因）; 
 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）; 
 
 
 bulkCopy.WriteToServer（dr）; // 
 
} 
} 
 

我尝试过：

无法兑换为数据源提供指定目标列的int类型的Double类型值。

解决方案

如果需要，可以使用类型转换默认的truncate-to-zero行为，但可能不适用于每个业务案例。或者，您可能想要使用

Math.Ceiling，Math.Round，Math.Floor等 - 尽管您之后仍需要演员。

Convert.ToInt32（ Math.Round（dblValue））



你需要处理溢出，因为int的范围小于double。

< blockquote>在您的阅读器查询中将列转换为int，然后类型将匹配。做类似这样的事情：



CAST（< some value> AS INT）

只有Cascade你的值，例如C代码...

  double  avg; 
 print（ ％lf，avg）; 
 sum =（ int ）avg + a; 
 print（ ％d，sum）; 

using (DbDataReader dr = command.ExecuteReader())
              {
                  // SQL Server Connection String
                  string sqlConnectionString = "Data Source=ACHRAF\\SQLEXPRESS;Initial Catalog=PFEBD;Integrated Security=True";

                  // Bulk Copy to SQL Server
                  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");


                      bulkCopy.WriteToServer(dr);//

                  }
              }

What I have tried:

Unable to convert the provided Double type value for the data source to the int type of the specified target column.

解决方案

You can use a typecast if you want the default truncate-towards-zero behaviour but that might not work for each business case. Alternatively, you might want to use
Math.Ceiling, Math.Round, Math.Floor etc - although you'll still need a cast afterwards.
Convert.ToInt32(Math.Round(dblValue))

you will need to take care of overflow as int is smaller in range than the double.

In your query for your reader convert the column to int, then the type will match. Do something like this:

CAST(<some value> AS INT)

Only Cascade your value for example like C code...

double avg;
print("%lf",avg);
sum  = (int)avg+a;
print("%d",sum);

这篇关于如何将double值转换为整数！ ！ ！的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！