how to display group inside datagridview

Question

Hi

 

I want to display  details  inside datagridview windows application.

I want to group vehicle type .

Please help me

Can I do it in SQL query or in datagridview c#  ?

 

---

 Vehicle type      Name   

---

 car

---

 

                       Hundai 

                       Benz  

                      Maruthi

 

---

Truck 

---

                    Ashok Leyland

                    TATA  

 

---

Thanks and regards

chandran