Easiest way to copy a dataview to a datatable in C#?

c# datatable dataview
Ravedave picture Ravedave · Apr 20, 2009 · Viewed 50.5k times · Source

I need to copy a dataview into a datatable. It seems like the only way to do so is to iterate through the dataview item by item and copy over to a datatable. There has to be a better way.

Answer

Jose Basilio picture Jose Basilio · Apr 20, 2009 
dt = DataView.ToTable()

OR

dt = DataView.Table.Copy(),

OR

dt = DataView.Table.Clone();

Related questions

How to bind dataGridView predefined columns with columns from sql statement (without adding new columns)?

Is there a elegant way, to bind predefined dataGridView columns with results from a SQL statement? Example: dataGridView1.Columns.Add("EID", "ID"); dataGridView1.Columns.Add("FName", "FirstName"); Some SQL like SELECT t.FirstName AS FName, t.EmpID AS EID FROM …

Read More
Sorted dataview to datatable

I have the following method: private DataTable getsortedtable(DataTable dt) { dt.DefaultView.Sort = "Name desc"; //I would need to return the datatable sorted. } My issue is that I cannot change the return type of this method and I have to …

Read More
Create ADO.NET DataView showing only selected Columns

In C# & .NET, can one create a DataView that includes only a proper subset of the DataColumns of a given DataTable? In terms of relational algebra, one assigns a RowFilter in order to perform a "selection" operation (σ). How would …

Read More