how to match excel sheet with datagridview in winforms

Question

I have an issue related , I want to match 3 columns of excel sheet with my 3 related columns of datagridview (data is coming from database), after matching, I want to classified it either which data is matched or which is not.

Answer 1

To center the column header text, you can do:

dataGridView1.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;

To set all the columns to the same width, I think you'll have to set them individually as I can't find a property to do this 'en bloc'.

Answer 2

thanks for your reply but I didnt get HorizontalAlign="Center" in HeaderStyle and ItemStyle

Can you please answer it specifically for datagrid view? and wherethese settings are??

Answer 3

try to give HorizontalAlign="Center" in HeaderStyle and ItemStyle