C# 多个table转成一个table的一行

最新推荐文章于 2024-01-21 11:07:42 发布
xhx夏
最新推荐文章于 2024-01-21 11:07:42 发布
阅读量382
点赞数
文章标签： C# table
本文链接：https://blog.youkuaiyun.com/u014328353/article/details/78223240
版权
本文介绍了一种使用C#创建DataTable的方法，通过定义多个DataColumn来构造一个包含多种客户相关信息的DataTable实例，并展示了如何填充数据。
摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >
 var dt = new DataTable();
            var columns = new DataColumn[] {
                new DataColumn("LINE_NO1", Type.GetType("System.String")),
                new DataColumn("KOKYAKUKANRI_NO1", Type.GetType("System.String")),
                new DataColumn("AYITETANTOSHA_CD1", Type.GetType("System.String")),
                new DataColumn("KOKYAKU_NM1", Type.GetType("System.String")),
                new DataColumn("AYITETANTOSHA_NM1", Type.GetType("System.String")),
                new DataColumn("ERROR_MSG1", Type.GetType("System.String")),
                new DataColumn("LINE_NO2", Type.GetType("System.String")),
                new DataColumn("KOKYAKUKANRI_NO2", Type.GetType("System.String")),
                new DataColumn("AYITETANTOSHA_CD2", Type.GetType("System.String")),
                new DataColumn("KOKYAKU_NM2", Type.GetType("System.String")),
                new DataColumn("AYITETANTOSHA_NM2", Type.GetType("System.String")),
                new DataColumn("ERROR_MSG2", Type.GetType("System.String")),
                new DataColumn("LINE_NO3", Type.GetType("System.String")),
                new DataColumn("KOKYAKUKANRI_NO3", Type.GetType("System.String")),
                new DataColumn("AYITETANTOSHA_CD3", Type.GetType("System.String")),
                new DataColumn("KOKYAKU_NM3", Type.GetType("System.String")),
                new DataColumn("AYITETANTOSHA_NM3", Type.GetType("System.String")),
                new DataColumn("ERROR_MSG3", Type.GetType("System.String")),
                new DataColumn("LINE_NO4", Type.GetType("System.String")),
                new DataColumn("KOKYAKUKANRI_NO4", Type.GetType("System.String")),
                new DataColumn("AYITETANTOSHA_CD4", Type.GetType("System.String")),
                new DataColumn("KOKYAKU_NM4", Type.GetType("System.String")),
                new DataColumn("AYITETANTOSHA_NM4", Type.GetType("System.String")),
                new DataColumn("ERROR_MSG4", Type.GetType("System.String")),
                new DataColumn("LINE_NO5", Type.GetType("System.String")),
                new DataColumn("KOKYAKUKANRI_NO5", Type.GetType("System.String")),
                new DataColumn("AYITETANTOSHA_CD5", Type.GetType("System.String")),
                new DataColumn("KOKYAKU_NM5", Type.GetType("System.String")),
                new DataColumn("AYITETANTOSHA_NM5", Type.GetType("System.String")),
                new DataColumn("ERROR_MSG5", Type.GetType("System.String")),
                new DataColumn("LINE_NO6", Type.GetType("System.String")),
                new DataColumn("KOKYAKUKANRI_NO6", Type.GetType("System.String")),
                new DataColumn("AYITETANTOSHA_CD6", Type.GetType("System.String")),
                new DataColumn("KOKYAKU_NM6", Type.GetType("System.String")),
                new DataColumn("AYITETANTOSHA_NM6", Type.GetType("System.String")),
                new DataColumn("ERROR_MSG6", Type.GetType("System.String")),
                new DataColumn("LINE_NO7", Type.GetType("System.String")),
                new DataColumn("KOKYAKUKANRI_NO7", Type.GetType("System.String")),
                new DataColumn("AYITETANTOSHA_CD7", Type.GetType("System.String")),
                new DataColumn("KOKYAKU_NM7", Type.GetType("System.String")),
                new DataColumn("AYITETANTOSHA_NM7", Type.GetType("System.String")),
                new DataColumn("ERROR_MSG7", Type.GetType("System.String")),
                new DataColumn("LINE_NO8", Type.GetType("System.String")),
                new DataColumn("KOKYAKUKANRI_NO8", Type.GetType("System.String")),
                new DataColumn("AYITETANTOSHA_CD8", Type.GetType("System.String")),
                new DataColumn("KOKYAKU_NM8", Type.GetType("System.String")),
                new DataColumn("AYITETANTOSHA_NM8", Type.GetType("System.String")),
                new DataColumn("ERROR_MSG8", Type.GetType("System.String")),
                new DataColumn("LINE_NO9", Type.GetType("System.String")),
                new DataColumn("KOKYAKUKANRI_NO9", Type.GetType("System.String")),
                new DataColumn("AYITETANTOSHA_CD9", Type.GetType("System.String")),
                new DataColumn("KOKYAKU_NM9", Type.GetType("System.String")),
                new DataColumn("AYITETANTOSHA_NM9", Type.GetType("System.String")),
                new DataColumn("ERROR_MSG9", Type.GetType("System.String")),
                new DataColumn("LINE_NO10", Type.GetType("System.String")),
                new DataColumn("KOKYAKUKANRI_NO10", Type.GetType("System.String")),
                new DataColumn("AYITETANTOSHA_CD10", Type.GetType("System.String")),
                new DataColumn("KOKYAKU_NM10", Type.GetType("System.String")),
                new DataColumn("AYITETANTOSHA_NM10", Type.GetType("System.String")),
                new DataColumn("ERROR_MSG10", Type.GetType("System.String"))
            };
            dt.Columns.AddRange(columns);
            DataRow dr = dt.NewRow();
            dt.Rows.Add(dr);
            int i = 0;
            for (int j = 0; j < desctd.Rows.Count; j++)
            {
                for (int k = 0; k < desctd.Columns.Count; k++)
                {
                    if (desctd.Rows[j][k].ToString().Length > 0)
                    {
                        dt.Rows[0][i] = desctd.Rows[j][k].ToString();
                    }
                    else
                        dt.Rows[0][i] = "";
                    i++;
                }
            }
            return dt;
        }