How to get DataTable from System.Windows.Controls.DataGrid

Question

I need to create a function giveing DataGrid to the function and the function returns DataTable containing all columns and rows in the datagrid. I am using System.Windows.Controls.DataGrid. Unfortunetly DataGrid has no properties like Rows so I can loop trough and get all the data. It does have propeties like Columns but I can not get Column datatype from it.

Im stuck, please advice.

Answer 1

Hi,

try to create a new datatable object, after processing assign the datasource property to the datatable

dim d as new datatable

Grid Name=DataHolder

d=dataholder.datasource

Also for iterating through the columns of the DataGrid,try datagridviewcolumns

http://social.msdn.microsoft.com/Search/en-us?query=datagridview

http://msdn.microsoft.com/en-us/library/system.windows.forms.datagridview.aspx

Hope it helps

Regards,

A.Murugan

 

---

Please mark this post as answer if it solved your problem. Happy Programming!

Answer 2

I am using C# languge and System.Windows.DataGrid, not DataGridView.

Answer 3

If you have bound your DataGrid to a DataTable, you can easily get the dataTable as,   

DataTable table = myDataGrid.DataSource as DataTable;

 

---

Please mark this post as answer if it solved your problem. Happy Programming!

Answer 4

In wpf datagrid, rows are ItemSource.items... no Rows property!

Try itemsource property.

 var itemsSource = grid.ItemsSource as IEnumerable;
       
       foreach (var item in itemsSource)
       {
           var row = grid.ItemContainerGenerator.ContainerFromItem(item)
                                 as System.Windows.Controls.DataGridRow;
       }

---

Answer 5

No. My dataGrid itemssource is not bound to DataTable. My DataGrid.Itemssource is List<some object>.

 

Zain_Ali:

Ok now what I do have the DataGridRow, I still cant get objects from the row. I can not add DataGridRows to DataTable? I can only add DataRows to DataTable

Answer 6

O.K try this

 private object ValidateColumn(string columnName, DataRow row)
    {
        DataTable table = row.Table;
        DataColumn column = table.Columns[columnName];
        object cellValue = row[column.ColumnName];
        return cellValue;
   }

---

Answer 7

No, I have not bound my DataGrid to DataTable. My DataGrid.Itemssource = List<some datatype>.

Zain_Ali, how can I get items array now what I have row? I cant not add DataGridRow to DataTable. I can only add DataRows to DataTable and only DataRows have List<object> (itemsArray).

Help me out, allmost there...