如何调用此方法以及此方法中传递的内容 [英] How to call this method and what to pass in this method

查看:45
本文介绍了如何调用此方法以及此方法中传递的内容的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

public DataTable Merge(DataTable[] dataTables)
        {
            List<int> oList = new List<int>();
            DataTable mergedDataTable = new DataTable();
            foreach (DataTable dt in dataTables)
            {
                oList.Add(dt.Rows.Count);
                foreach (DataColumn dc in dt.Columns)
                {
                    mergedDataTable.Columns.Add(dt.TableName + "-" + dc.ColumnName, dc.DataType);
                }
                //mergedDataTable.Columns.Add(dt.TableName + "-" + "Space");
            }
            int temp = 0;
            for (int m = 0; m < oList.Count; m++)
            {
                for (int n = 0; n < oList.Count - 1; n++)
                {
                    if (oList[n] > oList[n + 1])
                    {
                        temp = oList[n + 1];
                        oList[n + 1] = oList[n];
                        oList[n] = temp;
                    }
                }
            }
            int maxRow = oList[oList.Count - 1];
            for (int o = 0; o < maxRow; o++)
            {
                DataRow newRow = mergedDataTable.NewRow();
                int mergedDataTableColumn = 0;
                foreach (DataTable dt in dataTables)
                {
                    if (dt.Rows.Count > o)
                    {
                        for (int k = 0; k < dt.Columns.Count; k++)
                        {
                            newRow[mergedDataTableColumn] = dt.Rows[o][k];
                            mergedDataTableColumn++;
                        }
                    }
                    else
                    {
                        for (int k = 0; k < dt.Columns.Count; k++)
                        {
                            newRow[mergedDataTableColumn] = DBNull.Value;
                            mergedDataTableColumn++;
                        }
                    }
                    //newRow[mergedDataTableColumn] = DBNull.Value;
                    //mergedDataTableColumn++;
                }
                mergedDataTable.Rows.Add(newRow);
            }
            return mergedDataTable;
        }





我的尝试:



如何调用此方法以及在此方法中传递的内容。 Plz help



What I have tried:

how to call this method and what to pass in this method. Plz help

推荐答案

DataTable [] 是一个 DataTable ... propramming 101。
DataTable[] is an array of DataTable ... propramming 101.


按照这个例子



Follow this example

DataTable dt1 = new DataTable("dt1");
            dt1.Columns.Add("Id");
            dt1.Columns.Add("Name");
            dt1.Rows.Add(1, "aa");

            DataTable dt2 = new DataTable("dt2");
            dt2.Columns.Add("Id");
            dt2.Columns.Add("Name");
            dt2.Rows.Add(2, "bb");

            DataTable Final = Merge(new DataTable[] { dt1, dt2 });


这篇关于如何调用此方法以及此方法中传递的内容的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆