Change color of a datagridview cell while entering data.

Question

1.00/5 (1 vote)

See more:

Dear All,
I want change cell color and style while entering data into it.
I used following code but not work. Please help me.
dataGridView1.Rows.Add(strAccountName).DefaultCellStyle.BackColor =Color.Yellow;
Please note that I want to change fore color and boldness.

What I have tried:

I tried following code but not working. Please siggest

dataGridView1.Rows.Add(strAccountName).DefaultCellStyle.BackColor =Color.Yellow;

Posted 27-Jul-16 2:19am

Ashraf680

Updated 27-Jul-16 2:56am

Add a Solution

2 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)

Karthik_Mahalingam · Answer 1 · 2016-07-27T02:44:00

Solution 1

use CellValueChanged and EditingControlShowing event, customize it depends on your need.

C#

private void dataGridView1_CellValueChanged(object sender, DataGridViewCellEventArgs e)
       {
           var cell = dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex];
           cell.Style = new DataGridViewCellStyle() { BackColor = Color.White };
           string fontName = "Microsoft Sans Serif";
           cell.Style.Font = new Font(fontName, 8.25f, FontStyle.Regular, GraphicsUnit.Pixel);

       }



       private void dataGridView1_EditingControlShowing(object sender, DataGridViewEditingControlShowingEventArgs e)
       {
           e.CellStyle.BackColor = Color.Yellow;
           e.CellStyle.Font = new Font(e.CellStyle.Font, FontStyle.Bold);

       }

Posted 27-Jul-16 2:44am

Karthik_Mahalingam

Updated 27-Jul-16 2:45am

v2

Comments

Ashraf680 28-Jul-16 1:08am

Sir,
I wand to add data to DataGridView with different color and style while clicking a button.Please note that changing color and style must happen when the data entering to the DataGridview. And this want to be dynamically.

Karthik_Mahalingam 28-Jul-16 2:18am

Hi Ashraf
these things you havent mentioned in the question..
i have given the solution for what you have asked.

provide more input clearly, i shall provide you better solution.

Ashraf680 28-Jul-16 4:21am

Thank you sir...

Ashraf680 28-Jul-16 4:28am

Please note that I want o generate a report in DataGridView as by taking data from two table. I created a sale Invoice. Main details (Party Name, Sale Invoice Number ..etc) storing in one table and Product details(Sale invoice Id,Product ID, Quantity, Rate...etc) storing in another table. While generating report, I have to take Party name from one table(I want to show this in color change with bold) and product details taking from second table(want to add in normal font and color).

Karthik_Mahalingam 28-Jul-16 4:33am

report or gridview..
report means we are going out of the topic. i would encourage you to post a new question.

Ashraf680 28-Jul-16 4:41am

Want to generate report in DataGridView with different color and style. If you have any idea please reply...

Karthik_Mahalingam 28-Jul-16 5:41am

excel report?

Ashraf680 28-Jul-16 6:34am

No sir....I mean datagridview...Please don't concentrate in "report" , i want to add data to dataGridview with giving color and bold while populating from database.

as like below example

dataGridView1.Rows.Add("The Main Headding to be show as bold and in color");
dataGridView1.Rows.Add("The Second part to be show in normal font and in no color");

Karthik_Mahalingam 28-Jul-16 6:47am

are you adding row by row or binding it to a datasource?

Ashraf680 28-Jul-16 7:58am

row by row

Karthik_Mahalingam 28-Jul-16 8:01am

so you want to change font for whole row ?

Karthik_Mahalingam 28-Jul-16 8:19am

try like this

dataGridView.Row[index].DefaultCellStyle.BackColor = Color.Yellow

vatsa_gaurav · Answer 2 · 2016-07-27T02:56:00

Hi try this

private DataGridViewTextBoxEditingControl withEventsField_EditControl;
private DataGridViewTextBoxEditingControl EditControl {
get { return withEventsField_EditControl; }
set {
if (withEventsField_EditControl != null) {
withEventsField_EditControl.KeyDown -= EditControl_KeyDown;
}
withEventsField_EditControl = value;
if (withEventsField_EditControl != null) {
withEventsField_EditControl.KeyDown += EditControl_KeyDown;
}
}
}

private void DGV_EditingControlShowing(object sender, System.Windows.Forms.DataGridViewEditingControlShowingEventArgs e)
{
if (EditControl == null) {
EditControl = (DataGridViewTextBoxEditingControl)e.Control;
}
}
private void EditControl_KeyDown(object sender, System.Windows.Forms.KeyEventArgs e)
{
e.CellStyle.ForeColor = Color.Red;
e.CellStyle.BackColor = Color.Black;
e.CellStyle.Font = new Font(e.CellStyle.Font, FontStyle.Bold);
}