Number format in datagridview based on different columns value

Question

0.00/5 (No votes)

See more:

VS2008

Hi, I am working in VS 2008. I have a data grid view that have a column displaying numbers with decimals. A second column name Decimals. I need to set the first column's number decimals based on what is in the Decimals column. Example Number is 10.00000 and Decimals is 3. Now the Number column must b 10.000. I hope this makes sense. I hope I can do this in the data grid view's edit columns' format properties. I not then please help me with the code. Never done this before.

What I have tried:

I tried to put it in the data grid view's edit columns like N{Decimals.Value} bit it put Decimals1Value in the cell. I tried it in code but got stuck here.

For i As Integer = 0 To DataGridView1.Rows.Count

Next

I honestly don't know further. Please help!!!

Posted 22-Aug-17 21:06pm

The Manster

Updated 22-Aug-17 21:18pm

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Suvendu Shekhar Giri · Answer 1 · 2017-08-22T21:18:00

Solution 1

Try following -

VB

DataGridView1.Columns(2).DefaultCellStyle.Format = "N3"

Replace the column no. with actual column index.

More details here-
How to format Datagridview columns to numeric.?? Column.Defaultcellstyle.format does not work[^]

Hope, it helps :)

Posted 22-Aug-17 21:18pm

Suvendu Shekhar Giri

Comments

The Manster 23-Aug-17 3:22am

Thanks a span! The moment I read it I recognised it from previously. Forgot about it.

Suvendu Shekhar Giri 23-Aug-17 3:27am

Great!

The Manster 23-Aug-17 4:05am

Sorry I am back. I thought I could implement that with some changes but you see I have to loop through the rows and set cell's format to the value of a column.
For i As Integer = 0 To DataGridView1.Rows.Count
DataGridView1.Rows(i).Cells(dgvNumber.Index).??? =
DataGridView1.Rows(i).Cells(dgvDecimals.Index).Value
Next
??? means DefaultCellStyle does not work here and I don't know what to put there.