Specified cast is not valid

Question

0.00/5 (No votes)

See more:

List<Yearly> yearly = dataset.Tables[0].AsEnumerable()
               .Select(row => new Yearly
               {
                   Yearly_Rate = row.Field<float>("ATTRITION_RATE"),
                   Total_EmpCount = row.Field<int>("TOTAL_EMP"),
                   Resigned_EmpCount = row.Field<int>("RESIGNED_EMP")

               }).ToList();

In My Database ATTRITION_RATE is float, TOTAL_EMP is int, RESIGNED_EMP is int

What I have tried:

List<Yearly> yearly = dataset.Tables[0].AsEnumerable()
                .Select(row => new Yearly
                {
                    Yearly_Rate = row.Field<float>("ATTRITION_RATE"),
                    Total_EmpCount = row.Field<Int32>("TOTAL_EMP"),
                    Resigned_EmpCount = row.Field<Int32>("RESIGNED_EMP")

                }).ToList();

but still the same issue

Posted 1-Dec-20 3:48am

Virendra S from Bangalore, Karnataka

Updated 1-Dec-20 5:04am

Add a Solution

Comments

Richard MacCutchan 1-Dec-20 9:51am

Which line produces the error?

Virendra S from Bangalore, Karnataka 1-Dec-20 10:32am

.Select()

Richard MacCutchan 1-Dec-20 10:50am

You need to provide more information.

2 solutions

Solution 1

Use the debugger to look at your data table and it's content: something in it is not a float or an int, or is in the wrong column.

This kind of thing often happens when a DataTable is filled from a badly designed DB which stores numeric data as strings instead of as native numeric values - so when a column gets corrupted data, it shows up later as a casting problem.

You need to look at the data and work out what value is in error before you can go any further - and the start looking at how it got there and what you can do to fix it, then prevent it ever happening again!

Sorry, but we can't do that for you - we have no access to your running code or the data behind it!

Posted 1-Dec-20 4:12am

OriginalGriff

Comments

Virendra S from Bangalore, Karnataka 1-Dec-20 10:34am

My table data:

RESIGNED_EMP TOTAL_EMP ATTRITION_RATE
70 1180 5.882

OriginalGriff 1-Dec-20 10:38am

And what about all the other rows?

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)

Virendra S from Bangalore, Karnataka · Accepted Answer · 2020-12-01T05:04:00

I cross checked the datatype of the table value by using the below line. ATTRITION_RATE column data was double type..

System.Type type2 = ds.Tables[0].Rows[0][2].GetType();

List<Yearly> yearly = dataset.Tables[0].AsEnumerable()
                .Select(row => new Yearly
                {
                    Yearly_Rate = row.Field<double>("ATTRITION_RATE"),
                    Total_EmpCount = row.Field<int>("TOTAL_EMP"),
                    Resigned_EmpCount = row.Field<int>("RESIGNED_EMP")

                }).ToList();

casted the data accordingly, it is working