1-)  List<DataTable> daki tüm DataTable'ları Birleştirir.

List<DataTable> daki tüm DataTable'ları Birleştirir.

2-)Kullanımı

List<DataTable> WF_Tablolar= new List<DataTable>();

DataTable WF_TumTablolar= BordroUtils2.MergeAll(WF_Tablolar,"Donem_Id");

3-)List<DataTable> daki tüm DataTable'ları Birleştirir.

public static DataTable MergeAll(this IList<DataTable> tables, String primaryKeyColumn) {

            if (!tables.Any())

                throw new ArgumentException("Tables must not be empty", "tables");

            if (primaryKeyColumn != null)

                foreach (DataTable t in tables)

                    if (!t.Columns.Contains(primaryKeyColumn))

                        throw new ArgumentException("All tables must have the specified primarykey column " + primaryKeyColumn, "primaryKeyColumn");

            if (tables.Count == 1)

                return tables[0];

            DataTable table = new DataTable("TblUnion");

            table.BeginLoadData(); // Turns off notifications, index maintenance, and constraints while loading data

            foreach (DataTable t in tables) {

                table.Merge(t); // same as table.Merge(t, false, MissingSchemaAction.Add);

            }

            table.EndLoadData();

            if (primaryKeyColumn != null) {

                // since we might have no real primary keys defined, the rows now might have repeating fields

                // so now we're going to "join" these rows ...

                var pkGroups = table.AsEnumerable()

                    .GroupBy(r => r[primaryKeyColumn]);

                var dupGroups = pkGroups.Where(g => g.Count() > 1);

                foreach (var grpDup in dupGroups) {

                    // use first row and modify it

                    DataRow firstRow = grpDup.First();

                    foreach (DataColumn c in table.Columns) {

                        if (firstRow.IsNull(c)) {

                            DataRow firstNotNullRow = grpDup.Skip(1).FirstOrDefault(r => !r.IsNull(c));

                            if (firstNotNullRow != null)

                                firstRow[c] = firstNotNullRow[c];

                        }

                    }

                    // remove all but first row

                    var rowsToRemove = grpDup.Skip(1);

                    foreach (DataRow rowToRemove in rowsToRemove)

                        table.Rows.Remove(rowToRemove);

                }

            }

            return table;

        }