How to read value from a Cell from a WPF DataGrid?

Question

How to read a cell value form a WPF DataGrid?

I search online and try any possible combination and nothing works:

Datagrid.Cells[..], DataGrid.Items.Cells[..], DataGrid.Rows.., DataGrid.Items.Row.. nothing works, I can't find it is MSDN or I don't understand it. I just need to read a value off a cell in DataGrid that simple.

How to do it?

Metaplasm

Answer 1

Check this

http://social.msdn.microsoft.com/Forums/en/wpf/thread/74332b78-6bfd-4ac9-af85-dfd9bec87a29

http://wpfadventures.wordpress.com/2008/12/02/wpf-datagrid-detecting-clicked-cell-and-row/

WPF Toolkit DataGrid SelectionChanged Getting Cell Value

Vernice

from your answer it seems I have to write a helper function to get one cell value out of a DataGrid. I have hundreds of rows and multiple columns in my DataGrid. To get all values I have to loop through all rows and run the helper functions hundreds of time. Is there a quicker way? – Metaplasm

@Metaplasm It depends on what you are trying to do.Why do you want to loop through all the cells and get the data in cells ? You can simply use databinding to your code behind or viewmodel and loop your collection instead. – Vernice

I have to select a good number of cells in a DataGrid and output to an Excel sheet. That's why I'm looking for a more intuitive way to do that. I will reword my question and post a new question. – Metaplasm

@Vernice - Please edit this answer so it can be understood without following the links so we are safe from link-rot. – Vague

@Metaplasm No helpers should be needed. Learn XAML, use data binding. Doing this stuff in c# with XAML is always a mess -- you're fighting against the framework. He's helping you do it the wrong way, but it's still the wrong way. – Daw

Answer 2

This might help someone else.

foreach (DataRowView row in dgLista.SelectedItems)
{
    string text = row.Row.ItemArray[index].ToString();
}

Good luck!

Wasp

Answer 3

Here's a summary of the solution.

Winform

Type: System.windows.Forms.DataGridView

// C#
foreach (DataGridViewRow row in dataGridView1.Rows)
{
  //"Column1" = column name in DataGridView
  string text = row.Cells["Column1"].value.ToString();   
}

WPF equivalent

Type: DataGrid

// C#
foreach (DataRowView row in dataGrid.Items)
{
  string text = row.Row.ItemArray[index].ToString();
}

Baden

Answer 4

for wpf use:

DataRowView item = dataGrid.Items[rowIndex] as DataRowView;
Console.WriteLine(item.Row.ItemArray[columIndex]);

Genotype

Answer 5

The following helped me:

Private Sub dgNames_MouseDoubleClick(sender As Object, e As MouseButtonEventArgs) Handles dgNames.MouseDoubleClick

    Dim strCellContent as String = MessageBox.Show(TryCast(e.OriginalSource, TextBlock).Text)

End Sub

Cockayne

Answer 6

foreach (DataRowView row in pokemonGrid.SelectedItems)
{
    string text = row["columnName"].ToString();
    Trace.WriteLine(text);
}

This worked for me! Thanks to @BlackCath for pointing me in the right direction :)

Logistic