2
Answers

Rounding Large Dollar amounts

Photo of Thomas

Thomas

13y
1.1k
1
I want to round a double value to the nearest $100,000 (i.e. $3,456,789 = $3.500,000)

However this needs to be done as a string because it is a label for an open source Chart drawing tool that takes a string to create the labels.

Any suggestions?

Answers (2)

0
Photo of write2jey
NA 69 0 20y
listView.Items.Add(fileName) will add the parent item in the list view. Then you'd issue, listView.SubItems.Add(subItem) to add subitems under the parent item in ONE row. Imagine how the Windows Explorer displays files. First Filename, Data, Size, etc etc. That's what it does. So, retrieve the data from using data reader and insert it right in the list view; listView.Items.Add(dataReaderReadItem); listView.SubItems.Add(dataReaderReadItemFromtheNextColumnInTheRow); If you need to do casting before adding..take care of that . Regards, JJ
0
Photo of Boblysan
NA 66 0 20y
Unfortunately it didn't.. :( What does the following line actually add in to the list view??? anything? listview.Items.Add(fileName); I am sort of new to all this so please forgive me.. I have a database which I can successfully connect to. I am trying to use the data reader to read records from a table and then populate this information in to the list view. I guess I don't understand how I can get the information from the DB... reader.GetInt32(0).tostring(), **as information for column 1 ** reader.GetString(1).tostring(), ** as information for column 2 **... etc.. Thanks, Bob
0
Photo of write2jey
NA 69 0 20y
You'll have to add the columns first, which you know how. Then add subitems under the columns: Follow this: listview.Items.Add(fileName); //fileName is your parent Column listview.Items[count].SubItems.Add(size); //size is the child under the Parent Column listview.Items[count].SubItems.Add(date); //another child. so this will look like in ListView with 3 columns. First row is the column. File Name Size Date fileName1 size1 date1 fileName2 size2 date2 Hope that helps. JJ