updating Datatable values in winforms

Question

0.00/5 (No votes)

See more:

Hi,
I have a datatable which is having 3 rows ,3 columns (min %,max%,default%)
and the values are string type and values are like 2%,5% etc...
now i want to remove percentage(%) in all the values in the table...ie the column values should be 2,5 etc...

Please help me regarding the same..

Posted 10-May-11 20:24pm

siva455

Add a Solution

3 solutions

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)

RAJI @Codeproject · Answer 1 · 2011-05-10T21:16:00

Solution 2

To Sort the Colmns:

dt.DefaultView.Sort="Column Name";

And to add % when you display:

Convert.ToString (row[col])+"%";

Posted 10-May-11 21:16pm

RAJI @Codeproject

Updated 10-May-11 21:24pm

v2

Comments

siva455 11-May-11 3:21am

im not concern about sorting ...im asking how can i add % to values so that i need to display as 2%,3%...(as i removed % for sorting purpose and i want to revert it while displaying...)

RAJI @Codeproject 11-May-11 3:28am

is that helped?

siva455 11-May-11 4:18am

actually no...bcos i need to add % to values to which i have removed % earlier,not to all the columns...even i need to update the datatable also..

RAJI @Codeproject · Answer 2 · 2011-05-10T20:44:00

Solution 1

Try this!

foreach (DataRow row in dt.Rows)
           {
             foreach (DataColumn col in dt.Columns){

             string h= Convert.ToString (row[col]);
              row[col]=  h.Replace ("%","");
            } 

           }

           dt.AcceptChanges();

Posted 10-May-11 20:44pm

RAJI @Codeproject

Updated 10-May-11 20:46pm

v2

Comments

siva455 11-May-11 3:01am

thanks for ur reply..even without AcceptChanges() also it"s working...and one more thing actually i want to remove % as i want to sort the columns...now when im displaying i want to display values with %...please let me know how can i achieve the same....

BobJanova · Answer 3 · 2011-05-10T23:17:00

Solution 3

Those columns should be numeric to start with. Wherever you are creating the data table (and in the input validator if you expect the user to enter numbers that way), convert to the actual numeric value, and when you display values, apply the appropriate formatter.

If you're using a DataGridView the hooks you want are DataGridView.CellValidating (for input) and DataGridViewColumn.DefaultCellStyle.FormatString (for display).

Posted 10-May-11 23:17pm

BobJanova

Comments

siva455 12-May-11 0:32am

no user input here

BobJanova 12-May-11 13:51pm

Then just set the DataGridViewColumn.DefaultCellStyle.FormatString for the column to format the numbers as percentages.