合并数据表中的行 [英] Merge Rows in Datatable

问题描述

大家好，

Hi All,

Using SQL server i will fill datatable with values like,

EX:
id	name	tests
1	a	test1
1	a	test2
1	a	test3
1	a	test4
1	a	test5


But i need to show data in the datatable like,

id	name tests
1	a	test1
		test2
		test3
		test4
		test5
Can You please help me for doing this in c#

推荐答案

Hi,

 class SampleData
    {
        public string Id { get; set; }
        public string Name { get; set; }
        public List<string> Tests { get; set; }

    }

private void Button_Click_1(object sender, RoutedEventArgs e)
        {
            DataTable dt = new DataTable();
            //Fill DataTable
            List<sampledata> data = new List<sampledata>();
            foreach (DataRow dr in dt.Rows)
            {
                if (data.Where(sd => sd.Id == dr["Id"].ToString()).ToList().Count == 0)
                {
                    SampleData sampleData = new SampleData();
                    sampleData.Id = dr["Id"].ToString();
                    sampleData.Name = dr["Name"].ToString();
                    sampleData.Tests = new List<string>();
                    sampleData.Tests.Add(dr["Test"].ToString());
                    
                }
                else
                {
                    SampleData s = data.Single(sd => sd.Id == dr["Id"].ToString());
                    s.Tests.Add(dr["Test"].ToString());
                }
            }
        }
</string></sampledata></sampledata></string>

这篇关于合并数据表中的行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！