Role through a datagridview - set readonly as datagridview gets populated

Hi, the "Accepted Answer" is checked.
Once again Thanks - Until Later

Thank You very much, your patience & help.
I done exactly that add column to grid
if (dgvCurrentRow.Cells[12].Value.ToString() == "Found")
Thank You :)

I don't have problem setting the style.
I'm using the RowsAdded event, it goes through the grid rows.
But i have to test for a value in the the underlying data of the grid - (that is not displayed on the grid) to set the style.
for (int i = 0; i < e.RowCount; ++i){
dgvCurrentRow = dgvDetail.Rows[i + e.RowIndex];
* if (dgvDetail.CurrentRow.DataGridView.CurrentRow. == "Found")   *
I can't get hold of the column to check the alue I can see it on the databinding  - current row - when i put a break but actually coding is difficult.
The column exists in my table but not displayed on my grid and i'm going through the grid!
Please Assist - I have to get this going!
Regards

How about-:
dgvDetail[i].DefaultCellStyle.BackColor = Color.Red;
I am getting confused about your actual problem now.

Apologies my explaining is not good.
I tried again but unsuccessful
for (int i = 0; i < 1; ++i)   //does not work
{ dgvCurrentRow = dgvDetail[i];  //does not work
   dgvCurrentRow.DefaultCellStyle.BackColor = this.BackColor;

hey there,
what does... 'Could it be that the oLOTXLOCXID_BS only occurs once for the first record if so how do i check a value of a grid row ??' means?.
Is oLOTXLOCXID_BS a datatable. You need to check your logic as well, the string that you are matching must be there in all records.
and in case of DataBindComplete event you don't need [i+e.RowIndex].. you just have to scroll through all records using grd[i].

Hi, i tried both - the event only triggers once DataBindingComplete and displays only the first record with a match
on the rowsadded event: it loops through the same record all the time & sets only the first match
if (oLOTXLOCXID_BS.Current != null)
{oLOTXLOCXID_Row = (DataRowView)oLOTXLOCXID_BS.Current;
  if (dgvDetail.CurrentRow != null){
    for (int i = 0; i < e.RowCount; ++i){
     dgvCurrentRow = dgvDetail.Rows[i + e.RowIndex];
     if (oLOTXLOCXID_Row["WhsLPNo"].ToString() == "Found")
     {dgvCurrentRow.ReadOnly = true;dgvCurrentRow.Cells[10].Value = 1;}
 
Could it be that the oLOTXLOCXID_BS only occurs once for the first record if so how do i check a value of a grid row ??

if you are using databinding for datagridview then in that case this event might not work. For the first time databinding is done you can set colour for all rows after binding is complete or in DataBindingComplete event of datagridview.
If row is added programmitally in dataset for that case RowAdded event works apart from that there is also UserAddedRow event which works when user is allowed to enter a row.
i hope you'll get through with it.

Hi,
The RowsAdded event is triggered once for several rows
You should iterate the rows like this:
for( int i = 0; i < e.RowCount; ++i)
{
    dataGridView1.Rows[i + e.RowIndex] ...
}

Please mark this post as an answer if it helps you

Nir

Hi, I tried but also unsuccessful.
I put a break on the event & it only entered the event twice & it worked only for the second row.
Others not - it did not even go to the event for the other rows.
So out of the 4 rows that showed have been visibly disabled only the second row was disabled
?

hi ic ic,
you should write that code on row_added event.
that way effect will be given each time a row is added in the grid.