C# – How to get DataGridViewRow from CellFormatting event

cdatagridviewnetwinforms

I have a DataGridView and handle event CellFormatting. It has a parameter called:

DataGridViewCellFormattingEventArgs e

With

e.RowIndex in it.

When i do:

DataGridView.Rows[e.RowIndex]

I get proper row from collection.

But when I click at a header of a column to sort it by other column than default one and user DataGridView.Rows[e.RowIndex] I get unproper row.

It is because Rows collection do not reflect order of rows in DataGridView.

So how to get propert DataGridViewRow from RowIndex in DataGridView?

Best Answer

If my understanding is correct, you want to perform formatting for certain rows based on their index in the datasource, not based on the display index. In this case, you can use the DataBoundItem property of the DataGridViewRow. Considering that your datasource is a datatable, this item will be a DataGridViewRow, which has a property called Row, for which you can find the index in your original datasource. See below an example:

DataTable t = new DataTable(); //your datasource
int theIndexIWant = 3;

private void dataGridView1_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{               
    DataRowView row = dataGridView1.Rows[e.RowIndex].DataBoundItem as DataRowView;      

    if (row != null && t.Rows.IndexOf(row.Row) == theIndexIWant)
    {
        e.CellStyle.BackColor = Color.Red;
    }
}

Related Solutions

C# – How to calculate someone’s age based on a DateTime type birthday

An easy to understand and simple solution.

// Save today's date.
var today = DateTime.Today;

// Calculate the age.
var age = today.Year - birthdate.Year;

// Go back to the year in which the person was born in case of a leap year
if (birthdate.Date > today.AddYears(-age)) age--;

However, this assumes you are looking for the western idea of the age and not using East Asian reckoning.

C# – How to cast int to enum

From an int:

YourEnum foo = (YourEnum)yourInt;

From a string:

YourEnum foo = (YourEnum) Enum.Parse(typeof(YourEnum), yourString);

// The foo.ToString().Contains(",") check is necessary for enumerations marked with an [Flags] attribute
if (!Enum.IsDefined(typeof(YourEnum), foo) && !foo.ToString().Contains(","))
{
    throw new InvalidOperationException($"{yourString} is not an underlying value of the YourEnum enumeration.")
}

Update:

From number you can also

YourEnum foo = (YourEnum)Enum.ToObject(typeof(YourEnum) , yourInt);

Best Answer

Related Solutions

C# – How to calculate someone’s age based on a DateTime type birthday

C# – How to cast int to enum

Related Topic