How to concate multiple rows in one row?

Question

Hi members,

 

The subject is very familier and I have been searched on net so far but no solution works for me. I want a "Select" (or "Insert") query for concate rows. I want to fetch some data from data table and show in a DataGridView.

Kindly check the screen shot attached, it describes much better way.

1. either I fetch records into a DataGridView by select query or...

2. first insert record in a temporaty table then fetch into the DataGridView.

 

Please Help...

 

Mayank Jani