Change Color of a datagridview Cell while entering data.

Question

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 forecolor and boldness.

Tapan Patel · Answer

You can try this. Actually I am just defining how cell should look like when editing. EmployeeName Width= * Binding= {BindingFirstName} IsReadOnly= False > TextBox > Background Value= Red /> Please mark it as answer if it resolves the issue.

Mohammed Ashraf · Answer

I want to get my DataGridView like this

Dorababu Meka · Answer

Can you share us a screenshot how you want to display the report or any tools that you are using to generate reports?

ali tuncer · Answer

if you want to change after you add rowtry this way : dataGridView1.Rows.Add(Inv Date -  + strDate); dataGridView1.Rows[dataGridView1.Rows.Count-2].DefaultCellStyle.ForeColor = Color.Blue; dataGridView1.Rows[dataGridView1.Rows.Count-2].DefaultCellStyle.Font = new Font(DataGridView.DefaultFont FontStyle.Bold) or you can use foreach loop after binding every row to datagrid: foreach (DataGridViewRow row in dataGridView1.Rows) { row.DefaultCellStyle.ForeColor = Color.Blue; row.DefaultCellStyle.Font = new Font(DataGridView.DefaultFont FontStyle.Bold); }

Mohammed Ashraf · Answer

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 IdProduct 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). In the time of adding data or generating the report I want to show in different color as party name in boldness with color change and product details in normal font and color

Dorababu Meka · Answer

You want for every cell or a row on clicking add button you are adding the row. So before clicking on adding row you need the grid to be painted or after adding the row to grid

Mohammed Ashraf · Answer

Sir I am using windows form not asp.net. And I wand to add data to DataGridView with different color and style while clicking a button.

Mohammed Ashraf · Answer

Button click event Full code below private void btnShow_Click(object sender EventArgs e) { dmlTotal = 0; if (this.dataGridView1.DataSource != null) { this.dataGridView1.DataSource = null; } else { dataGridView1.Rows.Clear(); } strDate = 01-01-1899; IdFindMethod(Account AccountId AccountName comboBox1.Text out strAccountId); try { String Query = SELECT SalesInvIdSalesInvNoPartyAccountIdSalesDateGrandDiscount FROM SalesEstimateMaster where PartyAccountId ' + strAccountId + ' and SalesDate between ' + dateTimePicker1.Text + ' and ' + dateTimePicker2.Text + ' order by SalesDateSalesInvNo; cmd.Connection = con; SqlDataAdapter da = new SqlDataAdapter(Query con); DataTable dt = new DataTable(); da.Fill(dt); foreach (DataRow drw in dt.Rows) { if (drw[3].ToString() != strDate) { strDate = drw[3].ToString(); dataGridView1.Rows.Add(Inv Date -  + strDate); } strSalesInvId = drw[SalesInvId].ToString(); strAccountId = drw[PartyAccountId].ToString(); IdFindMethod(Account AccountName AccountId strAccountId out strAccountName); dataGridView1.Rows.Add(Inv No-  + drw[1].ToString() +  [ + strAccountName + ]); ProductAddMethod(); dataGridView1.Rows.Add(      Total drw[4]); dmlTotal = dmlTotal + Convert.ToDecimal(drw[4].ToString()); } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { con.Close(); } dataGridView1.Rows.Add(      Net Total dmlTotal); }

Dorababu Meka · Answer

In which event you are handling this?