How to add percentage symbol(%)

Question

0.00/5 (No votes)

See more:

Hi Frnds,
I wan to add % symbol as suffix in percentage column value in datatable in C# code.

What I have tried:

I already tried with:

foreach (DataRow drow in dt.Rows)
{
drow["PER"] = string.Concat(drow.Field<decimal>("PER"), "%");
}

Here my PER column was in decimal value . I can't concat the values. Anyone please help to resolve the issue.

Thanks in Advance.

Posted 22-Mar-18 20:48pm

Novaa

Updated 22-Mar-18 21:22pm

Add a Solution

2 solutions

Solution 2

You can't simply add [%] right after the number. A PER column is type of numeric (probably decimal), so it can't store a text!

To resolve it, you can add computed/expression column[^]. See:

C#

DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("PER", typeof(decimal)));
dt.Rows.Add(new object[]{0.85});
dt.Rows.Add(new object[]{0.99});
dt.Rows.Add(new object[]{0.67});
dt.Rows.Add(new object[]{0.46});
dt.Rows.Add(new object[]{0.27});

DataColumn dc = new DataColumn("PER2", typeof(string));
dc.Expression = "(PER*100) + '%'";
dt.Columns.Add(dc);

Result:

PER  PER2
0,85 85,00% 
0,99 99,00% 
0,67 67,00% 
0,46 46,00% 
0,27 27,00%

For further details, please see: DataColumn.Expression Property (System.Data)[^]

Posted 22-Mar-18 21:24pm

Maciej Los

Updated 22-Mar-18 21:30pm

v2

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 · 2018-03-22T20:56:00

Don't try to change your DataTable - that's a bad idea as it may be linked to the data source. And adding a "%" to the source would mean changing it from a numeric value to a string, which would be a very bad idea!

Instead, look at formatting the data when you present it to the user - DataGridView and suchlike all have formatting options which would allow you to display the percentage sign you require. I can't tell you what to do - I have no idea what you are using the DataTable with, or even the environment you are presenting data in - but the MSDN documentation should be able to help if you Google the control name and "Formatting".