Excel sheet Upload in VS windows application

Question

0.00/5 (No votes)

See more:

Hi All
I uploading an excel in my windows application but my question is in one column values are like 1234.8 but I want to show like 1234.80 how can I make this please help me

Here the column in the excel is general format and I loaded it on GridView now my Intention is modify the particular column in GridView so it should display 2 digit after decimal

Thanks & regards
Indrajit dasgupta

Posted 31-May-13 1:08am

IndrajitDasgupat

Updated 31-May-13 1:38am

v2

Add a Solution

Comments

Osman24 31-May-13 7:29am

Can you be more specific ?

Is it appropriate :
string s=string.Format("{0:0.00}",doubleValue);

IndrajitDasgupat 31-May-13 7:38am

Here the column in the excel is general format and I loaded it on GridView now my Intention is modify the particular column in GridView so it should display 2 digit after decimal

ZurdoDev 31-May-13 7:56am

Format your gridview column.

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)

Osman24 · Answer 1 · 2013-05-31T03:03:00

Solution 1

<asp:boundfield datafield="YourColumn" dataformatstring="{0:#.##}" />

I think it is what you need

Posted 31-May-13 3:03am

Osman24

Updated 31-May-13 3:04am

v2

Comments

[no name] 31-May-13 9:19am

How is this going to work for a Windows application as was clearly stated by the OP?

Osman24 31-May-13 9:22am

Sorry it is my bad but you said GridView yet in Windows Application it is DataGridView :). For it
yourcolumn.DefaultCellStyle.Format = "n2";
yourcolumn.ValueType = GetType(double);

I think it is something like that