All C# extension methods for type datatable

• ToXml

  Converts entire DataTabel To XDocument

  C# System.Data.DataTable Meysam Javadi Popular 8512 Views

• CreateExcel

  Transforms a DataTable in Excel (xls). Requires Excel Library (https://code.google.com/p/excellibrary/)

  C# System.Data.DataTable Raphael Augusto Ferroni Cardoso Popular 8248 Views

• SelectDistinct

  "SELECT DISTINCT" over a DataTable. Handles multiple columns selection.

  C# System.Data.DataTable Jonnidip Popular 7092 Views

• SelectRows

  Wraps the usage of some DataTable.DefaultView properties to return sorted rows filtered on a custom filterexpression. For documentation on what to put in the whereExpression and the orderByExpression, refer to the MSDN documentation of DataTable.DefaultView.RowFilter and DataTable.DefaultView.Sort.

  C# System.Data.DataTable Dan Pettersson Popular 6804 Views

• Dedup

  This method will take any DataTable and remove duplicate rows based on any column.

  C# System.Data.DataTable John D. Sanders 6105 Views

• EqualsByContent

  Checks if two DataTable objects have the same content.

  C# System.Data.DataTable Jonas Butt 5562 Views

• RenameColumn

  Rename a code that allows only stating the current name column and a new name.

  C# System.Data.DataTable Raphael Augusto Ferroni Cardoso 5171 Views

• WriteXMLForReport

  Many times you need an XSD file for a report. I have created this extension to write the xsd based on the data table I feed it into the directory I set.

  C# System.Data.DataTable John D. Sanders 4989 Views

• RemoveColumn

  Code that allows deleting a column stating the name

  C# System.Data.DataTable Raphael Augusto Ferroni Cardoso 4925 Views

• Perason Correlation Coefficient for a datatable

  An extension method that add the possibility calculate the Pearson correlation coefficient using the names of two columns of the data table in question.

  C# System.Data.DataTable Mahmood Salamah 4281 Views