I have a databound datagridview that has a percentage column using this format on the column: #0.##%. currently, the cell requires you to type the percentage as a decimal (.20 for 20%). It is then saved to the database as a decimal. I want the user to type 20 and have it save to the database as .20. How can I accomplish this? I considered writing some code to take what was writtan and multiply it by .01 on the cellendedit event. this might work, but is there an easier way to accomplish this?

Using cellendedit method is recommended. As an alternatively, you can handle cellformatting event. Check whether the cell value is bigger than 1, if so, multiplyby 0.01. There are many things need to be considered. The following code is not completed but can give a hint. You need to add more logic to get and set the value.

void dataGridView1_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)

{

if (e.ColumnIndex == 0)

{

if (e.Value != null && e.Value.ToString()!=""&& double.Parse(e.Value.ToString()) > 1 )

{

e.Value = double.Parse(e.Value.ToString()) * 0.01;

}

e.CellStyle.Format = "p";

}

}

Best regards,

Ling Wang

---

Please remember to click “Mark as Answer�on the post that helps you, and to click “Unmark as Answer�if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

I guess..... Nope !

---

Thanks

â™?My Blog â™?My Flickr â™?My Facebook â™?/div>

Using cellendedit method is recommended. As an alternatively, you can handle cellformatting event. Check whether the cell value is bigger than 1, if so, multiplyby 0.01. There are many things need to be considered. The following code is not completed but can give a hint. You need to add more logic to get and set the value.

void dataGridView1_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)

{

if (e.ColumnIndex == 0)

{

if (e.Value != null && e.Value.ToString()!=""&& double.Parse(e.Value.ToString()) > 1 )

{

e.Value = double.Parse(e.Value.ToString()) * 0.01;

}

e.CellStyle.Format = "p";

}

}

Best regards,

Ling Wang

---

Please remember to click “Mark as Answer�on the post that helps you, and to click “Unmark as Answer�if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.