473,698 Members | 2,588 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Problem with floating points in datagrid

Hi

I have a MSSQL database with has alot of numeric(18,2). I use LLBLGenPro as
O/R and it presents them as Decimals.

Fine. When i databind these O/R objects to a datagrid it "sees" that it´s 2
decimals and print it like: 14.00 even when no numbers are supplied.

The customer demand is now that when no the number is xx.00 it should be xx
and when xx.y0 it should be xx.y . Eg 14.00 => 14 and 14.70 => 14.7

I know i problably could change this dynamic parsing at dataBound event but
jeee thats a lot of redudant work.

Can you guys think of a smart "genric"´er way to achive this? My brain can
come up with anything near a smart solution.

Thanks in regards. Really.!

Anders
Nov 19 '05 #1
1 919
Anders:
This is normally done one of three ways...

1-expose a new readonly property in your entities which provide the
formatted number (you say you have a lot so this might not be the best
approac)

use inline formatting (2) or the onItemDataBound event (3)
http://openmymind.net/index.aspx?documentId=8
Karl

--
MY ASP.Net tutorials
http://www.openmymind.net/ - New and Improved (yes, the popup is annoying)
http://www.openmymind.net/faq.aspx - unofficial newsgroup FAQ (more to
come!)
"Anders K. Jacobsen [DK]" <no**@at.all> wrote in message
news:OP******** ******@TK2MSFTN GP14.phx.gbl...
Hi

I have a MSSQL database with has alot of numeric(18,2). I use LLBLGenPro as O/R and it presents them as Decimals.

Fine. When i databind these O/R objects to a datagrid it "sees" that it´s 2 decimals and print it like: 14.00 even when no numbers are supplied.

The customer demand is now that when no the number is xx.00 it should be xx and when xx.y0 it should be xx.y . Eg 14.00 => 14 and 14.70 => 14.7

I know i problably could change this dynamic parsing at dataBound event but jeee thats a lot of redudant work.

Can you guys think of a smart "genric"´er way to achive this? My brain can
come up with anything near a smart solution.

Thanks in regards. Really.!

Anders

Nov 19 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
2536
by: David E. | last post by:
Here's somewhat of an interesting problem. I am creating a class called Rectangle. It takes in 4 sets of Cartesian coordinates (i.e. (x,y) coordinates.). I'm assuming that the rectangle can be rotated too when receiving these coordinates. How would I go about setting methods to A>"order" them (so that when i trace the outsides, point A,B,C,D all are continous, as opposed to crossing in the "middle"... B> testing that they are equal sides...
0
1153
by: Michael Hall | last post by:
Hi All: I'm a relative newbie to Python, apart from some CGI and shell scripting type stuff. Anyway, I'm having some problems doing maths in Python 2.2.2 on RH9. I'm wondering what is the best way or numerical data type to do simple monetary calculations in Python? I only need to work with decimal numbers to two decimal points. Are floating point numbers the only option? They're giving me hell! If floating point numbers are the only...
10
4807
by: Mr Doppino | last post by:
Hi people, I would like to submit a problem about double comparison. Here's the code: struct Cross_point { int cross_id; int x, y; int street_oriz, street_vert; }; --------------------------------
5
2686
by: towers | last post by:
Hello, I've got a bit of experience in C++, but I'm writing my first app that is dependent on relatively precise math functions. The app requires that I get a time stamp based on s sample number, from a time series. This seems liek an easy thing to do: long lSample = 500; (for example) double dSampleRate = 1000.0;
13
4134
by: Bern McCarty | last post by:
I have run an experiment to try to learn some things about floating point performance in managed C++. I am using Visual Studio 2003. I was hoping to get a feel for whether or not it would make sense to punch out from managed code to native code (I was using IJW) in order to do some amount of floating point work and, if so, what that certain amount of floating point work was approximately. To attempt to do this I made a program that...
1
2268
by: Kevin Hodgson | last post by:
I'm having a strange problem with a VB.NET App, and the built in Windows.Forms.Datagrid I have a tabbed interface, and a DataGrid (along with other controls) on each of my two Tabs. If the Datagrid on my first Tab has a horizontal scrollbar automatically drawn because the table is too wide, and I switch to the other tab and resize the form, when I switch back to the first tab, the horizontal scrollbar on the datagrid is in the same...
39
19634
by: Martin Jørgensen | last post by:
Hi, I'm relatively new with C-programming and even though I've read about pointers and arrays many times, it's a topic that is a little confusing to me - at least at this moment: ---- 1) What's the difference between these 3 statements: (i) memcpy(&b, &KoefD, n); // this works somewhere in my code
18
1989
by: atv | last post by:
at least to me it is. I can't figure out for the life what it is i'm doing wrong here. i have a function called assign_coordinate. usually, i pass a malloced pointer to it, then individual pointers are malloced within that function. No problem here. Now i have a situation in this software, where i need to assign new coordinates to all nodes in the list.
7
2580
by: bummerland | last post by:
Hi, I have a problem with the function fmod. Why is fmod(5.7, 0.1) = 0.1 ?? Why is it not 0? tia bummerland
0
8680
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9030
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8899
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8871
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
6528
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5861
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4371
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
3052
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
2007
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.