Hi,

I have a Windows Form containing a Grid Control which displays a simple list of values from DB.

I would like to change the background color of  the row according to the value of data retrieved from DB on initial load of the form.

ex: if  value of column is YES the row should be gray in color.

Any help would be appreciated.

Thanks,

Ravs 

Use the AddingDataRow event, and set the color accordingly in the event handler.

e.g:

private void Form1_Load(object sender, EventArgs e)

    gridControl1.AddingDataRow += new AddingDataRowEventHandler(gridControl1_AddingDataRow);

}

void gridControl1_AddingDataRow( object sender, AddingDataRowEventArgs e )

    if( ( int )e.DataRow.Cells[ "ShipperID" ].Value == 2 )

        e.DataRow.BackColor = Color.Gray;

Thanks a lot!

It worked.