Datagridview Row backcolor problem

Question

Hi I am facing problem in changing datagridview rows color based on data. but in my datagrid last row containing total so I don't want to apply any background color on it.
I sent the cor or cellRormatting event of datagridview
Here I am using (e.RowIndex!= dgvRoomTypeSeven.Rows.Count-1) to check that it is last row.
but e.RowIndex always gives 0 why?

private void dgvRoomTypeSeven_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{

if (e.ColumnIndex != 0 && e.RowIndex!= dgvRoomTypeSeven.Rows.Count-1)
{
if (e.Value.ToString() == "N/A") e.CellStyle.BackColor = Color.Red;
else
e.CellStyle.BackColor = Color.Green;
}
}

Is there any other way?

Anil Kumar · Answer

Go for second option. check the row type at the RowDataBound and set the color. if (e.Row.RowType == DataControlRowType.Footer) Please check the event you are recieving. Proper event will give you the proper index value. For example if you opt above method you can recieve events in GridViewRowEventArgs e

Vikas Ahlawat · Answer

Ok thanx for your replies I am following second method. But if any one have the answers of my first question(e.Rowindex 0 why) then please reply.

Anil Kumar · Answer

Also check your own method by changing event to DataGridViewCellEventArgs

Vikas Ahlawat · Answer

Hi Anil I want to know that why e.RowIndex gives 0 every time. Because I want to apply it on CellFormatting event. or can you tell me any other event which is better for this task (applying loop).

Anil Kumar · Answer

Here you are trying to change the color of individual cell better to find the last row and change the color of row. (You can a the same using cell by cell also.) You can use GridViewRow after binding your GridView and set the color as - foreach ( GridViewRow row in myDataGridView . Rows ) { if ( ) { row . BackColor = Color . Red ; } } Or check the row type at the RowDataBound and set the color. if (e.Row.RowType == DataControlRowType.Footer)