How to display numeric data from database to textbox in two decimal places

Question

0.00/5 (No votes)

See more:

Hello :)

I would like to know on how to display to my textbox only 2 decimal places after loading the data from the database. Can anyone help me? here is my code on retrieving the data and put it inside the textbox :)

SqlCommand cmd = new SqlCommand("SELECT * from tblMiscellaneousFee WHERE GradeLevel = '" + grd_lvl.Text + "'", MySqlConnection);
               SqlDataReader rred = cmd.ExecuteReader();
               while (rred.Read())
               {
                   bookfee.Text = rred[2].ToString();
                   PEFee.Text = rred[3].ToString();
                   SchuniformFee.Text = rred[4].ToString();
                   MedicFee.Text = rred[5].ToString();
                   MiscFee.Text = rred[6].ToString();
                   tuitionFee.Text = rred[7].ToString();
                   totMisc.Text = MiscFee.Text;


               }
               rred.Close();

Posted 17-Jan-15 22:44pm

DarkDreamer08

Updated 17-Jan-15 22:45pm

v2

Add a Solution

Comments

Kornfeld Eliyahu Peter 18-Jan-15 5:00am

Check this: http://msdn.microsoft.com/en-us/library/fzeeb5cd(v=vs.110).aspx

DarkDreamer08 18-Jan-15 5:05am

sorry to say, i do not understand what the article is implying for.i am using a windows form application and not web forms. Sorry again :)

Kornfeld Eliyahu Peter 18-Jan-15 5:36am

And how is my link connected to web?

DarkDreamer08 18-Jan-15 5:43am

I am sorry. It is a windows form application codes. I am sorry to misunderstand your comment :) peace :)

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)

OriginalGriff · Accepted Answer · 2015-01-17T23:08:00

Assuming that it's your book fee that is the numeric value (if it isn't, then use the right values yourself).

First, convert it to an appropriate numeric type (appropriate in the case matching your DB column data type - so if it's FLOAT, use float or double; if it's DECIMAL use decimal. If it's NVARCHAR, change your database so it isn't - you should always store values in the most appropriate data type or it will give huge problems later on.

Then, format the data to a string.

C#

bookfee.Text = string.Format("{0:0.00}", (double) rred[2]);

BTW: You are doing things which combine to make one nasty source of bugs: you aren;t specifying the columns you want to retrieve (instead you get all of them), and you use numeric offsets to specify which column you use.
If you must use SELECT * FROM ... - and it's very inefficent, particularly if you aren't using all values, as you aren't - then you really have to use column names rather than numeric offsets. Otherwise you are relying on a column order that can be changed outside of your program - at which point things start to go very subtly and badly wrong: you can really muck up your database if you aren't very, very careful. List the columns you want, and only those, and use column names to access them from your reader.
Ans most seriously of all: Do not concatenate strings to build a SQL command. It leaves you wide open to accidental or deliberate SQL Injection attack which can destroy your entire database. Use Parametrized queries instead. The code you have there allows any user to delete your database just by typing in a text box...