Merge Same Data Column in DataGridView windows C#

Question

Hi
I have some data and i want to Merge Same Data Column in grid Like bellow
From :

Id	Name	ItemToBuy
1	mike	Toshiba portage
1	mike	Dell Latitude
2	nancy	Toshiba portage
2	nancy	Sony vioa
3	rosa	Asus
3	rosa	Hp
4	farid	Sony vioa

//------------------------------------------------------Show in grid like bellow

Id	Name	ItemToBuy
1	mike	Toshiba portage
		Dell Latitude
2	nancy	Toshiba portage
		Sony vioa
3	rosa	Asus
		Hp
4	farid	Sony vioa

Vulpes · Answer

Try something like this: // set up dgv dataGridView1.ColumnCount = 3; dataGridView1.Columns[0].HeaderText = "Id"; dataGridView1.Columns[1].HeaderText = "Name"; dataGridView1.Columns[2].HeaderText = "ItemToBuy"; dataGridView1.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.AllCellsExceptHeaders; dataGridView1.Columns[2].DefaultCellStyle.WrapMode = DataGridViewTriState.True; string[] data = { "1,mike,Toshiba portage", "1,mike,Dell latitude", "2,nancy,Toshiba portage", "2,nancy,Sony vaio", "3,rosa,Asus", "3,rosa,Hp", "4,farid,Sony vaio", "4,farid,Hp" }; // analyze data and create rows Dictionary dict = new Dictionary (); int rowNum = 0; foreach(string line in data) { string[] items = line.Split(','); if (dict.ContainsKey(items[0])) { dataGridView1.Rows[dict[items[0]]].Cells[2].Value += "
" + items[2]; } else { dict.Add(items[0], rowNum); dataGridView1.Rows.Add(items[0], items[1], items[2]); rowNum++; } }

ali salamat · Answer

Hi Vulpes thank you for replay but i want really separated row

Vulpes · Answer

You have to set the column's WrapMode property to true to get it to accept multiple lines of text in the first place. However, if you try the code, you'll see that the text is not actually wrapping because I'm using "
" to force a new line before the next computer name is added for a particular ID.

ali salamat · Answer

Hi Vulpes thank you but my problem not soled i want really to merge cell no wrap text

ali salamat · Answer

Hi Santhosh Kumar Thank you but my Problem not solved I dont want grouping plz see bellow image and link I want that my same data in two column Id and Name shows as Merge Like Excel and i dont want to use Hierarchical in my grid your sample merge data of ItemToBuy in one row thank you

Santhosh Kumar Jayaraman · Answer

try this DataTable dt = new DataTable(); DataRow dr = dt.NewRow(); dt.Columns.Add("Id", typeof(int)); dt.Columns.Add("Name", typeof(string)); dt.Columns.Add("ItemToBuy", typeof(string)); dr["Id"] = 1 ; dr["Name"] = "Mike"; dr["ItemToBuy"] = "Toshiba portage"; dt.Rows.Add(dr); DataRow dr1 = dt.NewRow(); dr1["Id"] = 1; dr1["Name"] = "Mike"; dr1["ItemToBuy"] = "Dell Latitude"; dt.Rows.Add(dr1); DataRow dr2 = dt.NewRow(); dr2["Id"] = 2; dr2["Name"] = "nacny"; dr2["ItemToBuy"] = "Dell Latitude"; dt.Rows.Add(dr2); DataTable dt1 = new DataTable(); dt1.Columns.Add("Id", typeof(int)); dt1.Columns.Add("Name", typeof(string)); dt1.Columns.Add("ItemToBuy", typeof(string)); var query = from row in dt.AsEnumerable() group row by row.Field ("Id") into grp select new { Id = grp.Key, name=grp.Select(m=>m.Field ("Name")).First(), Joined = string.Join(" ", grp.OrderBy(s => s.Field ("Id")) .Select(s => s.Field ("ItemToBuy"))) }; foreach (var grp in query) { DataRow row = dt1.NewRow(); row["ID"] = grp.Id; row["Name"] = grp.name; row["ItemToBuy"] = grp.Joined; dt1.Rows.Add(row); } Now in your datatable Dt1 you wil have the format as you wanted.. Check the attached solution

Merge Same Data Column in DataGridView windows C#

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (6)