different presentation of a float number in DB and webform

Question

I have a column named point in my database that its type is float .But when i try to read the value point column it shows me something like this :

2.000000000000000e+000

While the number is 2 why?I need to show me 2.

Here is the code that i read the value

public class viewpointShow
        {
            public string viewPointId { set; get; }
            public string point { set; get; }
            public string question { set; get; }
            public string JurorUserName { set; get; }
            public string articleId { set; get; }

        }
     List<viewpointShow> q =
                    (dbcontext.tblPoints.Where(i => i.ArtichleId.Value == int.Parse(articleId))
                              .Select(arg => new viewpointShow()
                                  {                             
                                     JurorUserName =arg.JurorUsername,
                                     articleId = arg.ArtichleId.ToString(),
                                     point = arg.Point.ToString(),
                                     question = ReturnQuestionById(arg.QuestionId.Value) 
                                  })).ToList();
            return q;

Best regards

Read http://stackoverflow.com/questions/2386772/difference-between-float-and-double and http://docs.oracle.com/cd/E19957-01/806-3568/ncg_goldberg.html — Aristos, Jun 29 '14 at 09:51
YOu know i just need how can i convert this 2.000000000000000e+000 to 2? — Mehrdad, Jun 29 '14 at 09:52
Why is float at the first place you need to wonder. You can convert it to int using Math functions, or format it using the string.format. — Aristos, Jun 29 '14 at 09:53
A float does not have a formatted representation of its own. It all depends on _how_ you convert it to a string. Post the HTML / ASPX. — H H, Jun 29 '14 at 09:55
Are you sure you want to keep your values as a `float` in your database? — Soner Gönül, Jun 29 '14 at 09:55
You know in database the type is float but when i import the table using linqtosql it's changed to double!!!!!! — Mehrdad, Jun 29 '14 at 10:15

score 1 · Accepted Answer · answered Jun 29 '14 at 10:04

1

You didn't specify how may decimals you want to see. Possible solutions

 //point = arg.Point.ToString()
   point = arg.Point.ToString("0.0", CultureInfo.InvariantCulture)    // always 1 decimal digit
   point = arg.Point.ToString("#.##", CultureInfo.InvariantCulture)   // at most 2

answered Jun 29 '14 at 10:04

H H

263,252
30
330
514

Method tostring has 0 parameter but is invoked with 2 parameteres – Mehrdad Jun 29 '14 at 10:06
I need to see 2 digit – Mehrdad Jun 29 '14 at 10:07
Then arg.Point is not a float. – H H Jun 29 '14 at 10:07
the type of that in database is float but here i want to show that as a string – Mehrdad Jun 29 '14 at 10:08
But `arg.Point` is not in the database, it has been read into memory. Find out the type. – H H Jun 29 '14 at 10:10
You know in database the type is float but when i import the table using linqtosql it's changed to double!!!!!! – Mehrdad Jun 29 '14 at 10:13
`double` has the same `ToString()`s as `float`. – H H Jun 29 '14 at 10:16

different presentation of a float number in DB and webform

1 Answers1