Data format string in c#

Question

2.00/5 (8 votes)

See more:

I want to do data format string function for my c# code.
string s = 0.98677;
this value come directlly from database table and catch it in string variable.
I want output only 0.98, then i use data format string.
string str = (s,"0:0.##");
or
string.format("0:0.00",s)
but this not give me exact answer upto 2 digit 0.98.
Please help me for my this problem.

regards,
Ravi

Posted 1-Jun-11 0:07am

Ravi Sharma 2

Updated 1-Jun-11 1:54am

Prerak Patel

v4

Add a Solution

Comments

Sergey Alexandrovich Kryukov 1-Jun-11 15:08pm

C# or VB.NET?!!! Tag properly.
--SA

9 solutions

Solution 8

Seems like you just want first to decimals, not rounding.
I mean 0.98 for 0.98677, not 0.99. If it is the case, use following function

C#

public string getValueUpto2Decimal(string value)
{
	if (value.Contains(".")) { 
		value += "00"; //to ensure that there are at least 2 digits after decimal point
	} else {
		value += ".00"; //place 00 after decimal
	}
	return value.Substring(0, value.IndexOf(".") + 3);
}

This is purely based on string functions.

Though I seriously have a doubt that you get a string value from database. If you get a double from database, then just use ToString() to pass it to the function.

Posted 1-Jun-11 2:05am

Prerak Patel

Solution 2

I must Suggest you to
Click Here [^]

Posted 1-Jun-11 0:29am

Karwa_Vivek

Solution 7

decimal d=.....
label1.text=string.format("{0:f2}",d);

Posted 1-Jun-11 1:49am

LakshmiNarayana Nalluri

Solution 1

u can use substring or remove method in c#

try this

MIDL

string s = "0.98677";
 s=s.Remove(4);

Posted 1-Jun-11 0:13am

Ashishmau

Comments

Quirkafleeg 1-Jun-11 6:52am

...and with a different string of, say "11.98677"?

Solution 4

Your data is a string, not a number, so numeric formatting strings will not work. You either need to manipulate it as a string (find the decimal separator and then take two more characters), or use double.Parse to get a number and then format that with a numeric format string.

Numbers should come out of a database as numbers, though. Have you set your database schema correctly?

Posted 1-Jun-11 0:40am

BobJanova

Solution 6

may this Work

double dNum = 0;
           dNum =0.98677;
           string.Format("{0:n4}", dNum);

Posted 1-Jun-11 0:46am

Karwa_Vivek

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)

Steven.Pinto2000 · Accepted Answer · 2011-06-01T02:47:00

Solution 9

Here is one more solution

C#

double   s = 0.93245;
           string s1= s.ToString("0.00");

Posted 1-Jun-11 2:47am

Steven.Pinto2000

Prasanta_Prince · Accepted Answer · 2011-06-01T00:39:00

Solution 3

Try with

string.format("{0:(#).##}",s)

It will work for sure,

Posted 1-Jun-11 0:39am

Prasanta_Prince

ambarishtv · Accepted Answer · 2011-06-01T00:42:00

Solution 5

try this code

C#

string s = "9.5688";
            double val ;
            if (Double.TryParse(s, out val))
            {
               String.Format("{0:0.00}", Math.Round(val, 2));

            }

output : 9.57

Posted 1-Jun-11 0:42am

ambarishtv

Comments

Ravi Sharma 2 1-Jun-11 8:42am

Thanks A lot for giving me perfect solution................