c# highlight certain rows

[AaronW]

I am trying to do conditional formatting of rows in a datagrid and can not get DataGridItemEventArgs as an option. Is there something wrong with the assembly?

using System;
using System.Drawing;
using System.Collections;
using System.Collections.Specialized;
using System.ComponentModel;
using System.Text.RegularExpressions;
using System.Threading;
using System.Windows.Forms;
using System.Data;
using System.Timers;

[Plater]

That is not much to go on.
Are you sure you're not looking at descriptions for DataGridView and not DataGrid?

[AaronW]

I am trying to loop through the datagrid and once I find a cell with certain information I would like to highlight the entire row.
--------------------------------------------------------------
private void BindUsers()
{
Domain = cboDomain.SelectedValue.ToString();
OU = cboOU.SelectedValue.ToString();
SiteCode = cboSite.SelectedValue.ToString();

DataSet ds = dsVendors(Domain, OU, SiteCode);
DataTable dt = ds.Tables["Vendors"];
dgMain.DataSource = dt;
dgMain.AlternatingBackColor = Color.LightSteelBlue;

// set the number of users
intNumUsers = dt.Rows.Count;

// finally compute our randomization
ComputeRandomMetrics();
}
--------------------------------------------------------------

I tried the following with the dataset but recieved sereval errors and figured I would be better off looping through the grid once the data is loaded.

private void DataGridView1_CellFormatting(object sender, System.Windows.Forms.DataGridViewCellFormattingEve ntArgs e)
{
DataRowView drv;
if (e.RowIndex >= 0) {
if (e.RowIndex <= ds.Tables("Vendors").Rows.Count - 1) {
drv = ds.Tables("Vendors").DefaultView.Item(e.RowIndex);
Color c;
if (drv.Item("location").ToString == "ACTION REQUIRED") {
c = Color.Red;
}
else {
c = Color.Black;
}
e.CellStyle.BackColor = c;
}
}
}

[Plater]

by higlight do you mean "select" or change the visible colors of?

[AaronW]

I would prefer to change the background color if possible.

[Plater]

Can't you set that on DataGridViewRow object?

[AaronW]

Got it with:

private void AddCellFormattingColumnStyles(DataGrid grid, FormatCellEventHandler handler)
{
DataGridTableStyle ts = new DataGridTableStyle();
DataTable dt = (DataTable) grid.DataSource;
ts.MappingName = dt.TableName;

for(int j = 0; j < dt.Columns.Count; ++j)
{
DataGridFormattableTextBoxColumn cs = new DataGridFormattableTextBoxColumn(j);
cs.MappingName = dt.Columns[j].ColumnName;
cs.HeaderText = dt.Columns[j].ColumnName;
cs.SetCellFormat += handler;
ts.GridColumnStyles.Add(cs);
}

//grid.TableStyles.Clear();
grid.TableStyles.Add(ts);

}

private void FormatGridCells(object sender, DataGridFormatCellEventArgs e)
{
CurrencyManager cm = (CurrencyManager)this.BindingContext[this.dgMain.DataSource];

object cellValue = this.dgMain[e.Row, 4];
if (cellValue.ToString() == "ACTION REQUIRED")
{
e.BackBrush = Brushes.Red;
}
}