How to create custom datagridview

See more:

C#

have problem for bind custom row and column in datagridview c# windows form

Hi, I have a datagridview in my winform and i have a sql table information (figure 1) :
figure1[^]

i want to bind those informations to datagridview like figure 2 :

figuer2[^]

how i can do that?
can i have dynamic code? for example when add another car code to table ,datagrid automaticaly add new info
I would appreciate if u helped me with this.

What I have tried:

//this code work fine to create datagridview for figure 1 :

str = " select * from V_ProductPlanYears where 1=1  ";
               SqlDataAdapter SqlDa = new SqlDataAdapter(str, conDb10);
               DataTable dt = new DataTable();
               SqlDa.Fill(dt);
               dgvProductPlanning.DataSource = dt;