2 // DataTableExtensions.cs
5 // Atsushi Enomoto <atsushi@ximian.com>
7 // Copyright (C) 2008 Novell, Inc. http://www.novell.com
11 // Permission is hereby granted, free of charge, to any person obtaining
12 // a copy of this software and associated documentation files (the
13 // "Software"), to deal in the Software without restriction, including
14 // without limitation the rights to use, copy, modify, merge, publish,
15 // distribute, sublicense, and/or sell copies of the Software, and to
16 // permit persons to whom the Software is furnished to do so, subject to
17 // the following conditions:
19 // The above copyright notice and this permission notice shall be
20 // included in all copies or substantial portions of the Software.
22 // THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
23 // EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
24 // MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
25 // NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE
26 // LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION
27 // OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION
28 // WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
32 using System.Collections;
33 using System.Collections.Generic;
40 public static class DataTableExtensions
42 public static DataView AsDataView (this DataTable table)
44 return AsDataView<DataRow> (table.AsEnumerable ());
47 [MonoTODO ("We should implement an effective DataView derivation; looks like .NET does.")]
48 public static DataView AsDataView<T> (this EnumerableRowCollection<T> source)
51 return CopyToDataTable<T> (source).DefaultView;
54 public static EnumerableRowCollection<DataRow> AsEnumerable (this DataTable source)
56 return new EnumerableRowCollection<DataRow> (new DataRowEnumerable<DataRow> (source));
59 public static DataTable CopyToDataTable<T> (this IEnumerable<T> source)
62 DataTable dt = new DataTable ();
63 IEnumerator<T> e = source.GetEnumerator ();
65 throw new InvalidOperationException ("The source contains no DataRows");
66 foreach (DataColumn col in e.Current.Table.Columns)
67 dt.Columns.Add (new DataColumn (col.ColumnName, col.DataType, col.Expression, col.ColumnMapping));
68 CopyToDataTable<T> (source, dt, LoadOption.PreserveChanges);
72 public static void CopyToDataTable<T> (this IEnumerable<T> source, DataTable table, LoadOption options)
75 CopyToDataTable<T> (source, table, options, null);
78 public static void CopyToDataTable<T> (this IEnumerable<T> source, DataTable table, LoadOption options, FillErrorEventHandler errorHandler)
81 var reader = new RowEnumerableDataReader (source, 0);
82 table.Load (reader, options, errorHandler);
86 class DataRowEnumerable<TRow> : IEnumerable<TRow>
90 public DataRowEnumerable (DataTable source)
95 public IEnumerator<TRow> GetEnumerator ()
97 foreach (TRow row in source.Rows)
101 IEnumerator IEnumerable.GetEnumerator ()
103 return GetEnumerator ();