Feb 4, 2016 · Why do you want to convert a strongly typed List<ViewQuoteItemList> to a loosely typed DataTable at all? You don't need the DataTable, you can use following LINQ query. var source = (List<ViewQuoteItemList>) dgFeedbackSelectSupplier.ItemsSource; int sum = source.Sum(x => x.Prop1 + x.Prop2 + x.Prop3); // change accordingly

If you are referring to the System.Windows.Forms.DataGrid or System.Web.UI.WebControls.DataGrid, then the best way would be to cast the Datasource property to a DataTable. Of course the Datasource property has to actually be a DataTable underlying type to begin with.

Sep 6, 2021 · I used the collection as the ItemsSource of the DataGrid and converted its data to the DataTable through the following code. And by displaying the DataTable in another DataGrid to check whether the data is successfully converted.

To convert a generic list to data table, you could use the DataTableGenerator. This library lets you convert your list into a data table with multi-feature like . Translate data table header ; specify some column to show

In real-world C# applications, especially when working with data layers or exporting data (e.g., to Excel, reports, or grids), you may often need to convert a generic list of objects (List&lt;T&gt;) to a DataTable. This article shows you how to do that in a clean, reusable way using reflection.

In this article, I will describe to you how to convert a List objects to a DataTable. Step 1: Create a console application and add the Student class with the properties as below.

Apr 16, 2010 · A simple way to convert an arbitrary collection of simple objects into a DataTable using LINQ and reflection.

Apr 29, 2024 · In this article, we'll explore efficient techniques for converting data from a list to a DataTable and vice versa, along with practical examples to illustrate each conversion process. The first scenario we'll cover is converting a list of custom objects to a DataTable.

Apr 24, 2009 · You should convert first DataSource in BindingSource, look example. BindingSource bs = (BindingSource)dgrid.DataSource; // Se convierte el DataSource DataTable tCxC = (DataTable) bs.DataSource; With the data of tCxC you can do anything.

Mar 25, 2025 · In this comprehensive guide, we’ll explore detailed step-by-step methods to fill DataSet or DataTable with LINQ query results, best practices, advanced considerations, common troubleshooting scenarios, and expert answers to frequently asked questions.