locked
MS Access double decimal value not coming properly in C# data table RRS feed

  • Question

  • I am using MS Access for storing database and front end is Win C#.NET

    In one of my table column is double and stored value is "7.8".

    When i read this value in my C# data table, i am getting only "7", not able to get full value "7.8"

    How it will come only "7" instead of "7.8".

    How to solve this issue...?

    Wednesday, May 6, 2020 5:18 PM

Answers

  • Is the field in access setup as follows?

    Here the first column is setup as a long integer while the second is as per above.


    Please remember to mark the replies as answers if they help and unmarked them if they provide no help, this will help others who are looking for solutions to the same or similar problem. Contact via my Twitter (Karen Payne) or Facebook (Karen Payne) via my MSDN profile but will not answer coding question on either.

    NuGet BaseConnectionLibrary for database connections.

    StackOverFlow
    profile for Karen Payne on Stack Exchange

    Wednesday, May 6, 2020 5:31 PM

All replies

  • Is the field in access setup as follows?

    Here the first column is setup as a long integer while the second is as per above.


    Please remember to mark the replies as answers if they help and unmarked them if they provide no help, this will help others who are looking for solutions to the same or similar problem. Contact via my Twitter (Karen Payne) or Facebook (Karen Payne) via my MSDN profile but will not answer coding question on either.

    NuGet BaseConnectionLibrary for database connections.

    StackOverFlow
    profile for Karen Payne on Stack Exchange

    Wednesday, May 6, 2020 5:31 PM
  • Thanks..it's working..i made small mistakes...Thanks for your help...
    Thursday, May 7, 2020 3:02 AM
  • Hi Gani tpt,

    It seems that your problem has been solved. Please click "Mark as answer" to Karen's reply, so that it will help other members to find the solution quickly if they face a similar issue.

    Best Regards,

    Timon


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Thursday, May 7, 2020 6:25 AM