How to modify the List view column?

Question

I have list view the data will be displayed in list view from data table like this i have done but i have problem at datarow 6

           dt = classes.xxxxx.GetData(sql, mf);

  if (dt != null)
  {
    ListViewItem newitem = null;
    lstviewcashmembers.Items.Clear();
    lstviewcashmembers.BeginUpdate();
    foreach (DataRow dr in dt.Rows)
    {
      newitem = lstviewcashmembers.Items.Add(dr[0].ToString());
      newitem.SubItems.Add(dr[1].ToString());
      newitem.SubItems.Add(dr[2].ToString());
      newitem.SubItems.Add(dr[3].ToString());
      newitem.SubItems.Add(dr[4].ToString());
      newitem.SubItems.Add(dr[5].ToString());
      newitem.SubItems.Add(dr[6].ToString());
      newitem.SubItems.Add(dr[7].ToString());
      newitem.SubItems.Add(dr[8].ToString());
      newitem.SubItems.Add(dr[9].ToString());
      newitem.SubItems.Add(dr[10].ToString());
      newitem = null;
    }

    lstviewcashmembers.EndUpdate();
  }

my problem is like I got original value coming from database is 25.00000 at dr[6]

I mean in this line newitem.SubItems.Add(dr[6].ToString());

But I have to show only two decimal places like this 25.00

Would any one help this?

valuable Question +1 for that. – Sagotharan Aug 02 '11 at 11:07 — Sagotharan, Aug 02 '11 at 11:07

Jason Down · Answer 1 · 2011-08-02T10:59:17.810

5

Use this:

dr[6].ToString("N2")

Update:

((double)dr[6]).ToString("N2")

The N2 must be done on a numeric type, so the cast is necessary on the DataRow object.

edited Aug 02 '11 at 10:59

answered Aug 02 '11 at 10:44

Jason Down

21,731
12
83
117

got an error No Over Load method for To string Takes one argument newitem.SubItems.Add(dr[6].ToString("N2")); – user682417 Aug 02 '11 at 10:49
@user682417: Hmmm, maybe dr[6] must be cast to a double first... updating answer – Jason Down Aug 02 '11 at 10:58

Massimiliano Peluso · Accepted Answer · 2011-08-02T11:01:40.587

1

try this:

 string r = "1000.123456";
 var t = string.Format("{0:#.##}",decimal.Parse(r)); //1000.12

edited Aug 02 '11 at 11:01

answered Aug 02 '11 at 10:46

Massimiliano Peluso

26,379
6
61
70

Sagotharan · Answer 3 · 2011-08-02T11:06:18.607

0

As Jason Down give the Correct Answer. Try dr[6].ToString("0.00") also

And try to read Standard Numeric Format Strings and Custom Numeric Format Strings For More Information About Format.

Happy Coding.

edited Aug 02 '11 at 11:06

answered Aug 02 '11 at 10:53

Sagotharan

2,586
16
73
117

How to modify the List view column?

3 Answers3