How to convert double value to integer! ! !

Question

1.00/5 (1 vote)

See more:

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.

Posted 14-May-18 6:48am

achraf boumessouer

Updated 14-May-18 8:49am

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Member 12810461 · Answer 1 · 2018-05-14T08:04:00

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.

loyal ginger · Answer 2 · 2018-05-14T08:17:00

Solution 2

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)

Posted 14-May-18 8:17am

loyal ginger

Kuldeep Kumar · Answer 3 · 2018-05-14T08:50:00

Solution 3

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

C++

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

Posted 14-May-18 8:50am

Kuldeep Kumar

Updated 14-May-18 9:00am

v2