DataGrid get selected rows column values

Question

I m trying to get the values of each column of a selected row in a DataGrid  This is what I have   private void dataGrid1 CellEditEnding object sender  DataGridCellEditEndingEventArgs e        DataGrid dg   sender as DataGrid      Console WriteLine dg SelectedCells 0  ToString         But this does not work  If I do a SelectedCells Count then I get the correct number of columns but I cannot seem to actually get the values of these columns in the selected row  I ve tried for quite a while with no luck  Here is my XAML    lt Grid gt       lt DataGrid CanUserAddRows  True  AutoGenerateColumns  False  Height  200  HorizontalAlignment  Stretch  Margin  12 12 79 0  Name  dataGrid1  VerticalAlignment  Top  Width  389  DataContext   Binding   CanUserResizeColumns  False  CanUserResizeRows  False  HorizontalContentAlignment  Stretch  PreviewMouseDoubleClick  dataGrid1 PreviewMouseDoubleClick  CellEditEnding  dataGrid1 CellEditEnding  gt           lt DataGrid Columns gt               lt DataGridTextColumn Binding   Binding  Path UserID                                   Header  User ID  Width  SizeToHeader    gt               lt DataGridTextColumn Binding   Binding  Path UserName                                   Header  User ID  Width  SizeToHeader    gt           lt  DataGrid Columns gt       lt  DataGrid gt   lt  Grid gt    I would ideally like to access the data through doing something like rowData UserID but I cannot seem to work it out  There are lots of tutorials and help for using DataGridView but I m not using this

User · Answer

DataGrid get selected rows  column values  it can be access by below code  Here grid1 is name of Gride   private void Edit Click object sender  RoutedEventArgs e        DataRowView rowview   grid1 SelectedItem as DataRowView      string id   rowview Row 0  ToString

User · Answer

If you are using an SQL query to populate your DataGrid you can do this   Datagrid fill Private Sub UserControl Loaded sender As Object  e As RoutedEventArgs          Dim cmd As SqlCommand         Dim da As SqlDataAdapter         Dim dt As DataTable          cmd   New SqlCommand With                CommandText    quot SELECT   FROM temp rech dossier route quot                Connection   connSQLServer                   da   New SqlDataAdapter cmd          dt   New DataTable  quot RECH quot           da Fill dt          DataGridRech ItemsSource   dt DefaultView End Sub  Value diplay     Private Sub DataGridRech SelectionChanged sender As Object  e As SelectionChangedEventArgs  Handles DataGridRech SelectionChanged         Dim val As DataRowView         val   CType DataGridRech SelectedItem  DataRowView          Console WriteLine val Row Item  quot num dos quot        End Sub  I know it s in VB Net but it can be translated into C   I put this solution here  it might be useful for someone

User · Answer

UPDATED  To get the selected rows try   IList rows   dg SelectedItems    You should then be able to get to the column value from a row item   OR  DataRowView row    DataRowView dg SelectedItems 0     Then   row  ColumnName

User · Answer

I did something similar but I use binding to get the selected item     lt DataGrid Grid Row  1  AutoGenerateColumns  False  Name  dataGrid            IsReadOnly  True  SelectionMode  Single            ItemsSource   Binding ObservableContactList              SelectedItem   Binding SelectedContact   gt     lt DataGrid Columns gt       lt DataGridTextColumn Binding   Binding Path Name   Header  Name   gt       lt DataGridTextColumn Binding   Binding Path FamilyName   Header  FamilyName   gt       lt DataGridTextColumn Binding   Binding Path Age   Header  Age   gt       lt DataGridTextColumn Binding   Binding Path Relation   Header  Relation   gt       lt DataGridTextColumn Binding   Binding Path Phone Display   Header  Phone   gt       lt DataGridTextColumn Binding   Binding Path Address Display   Header  Addr   gt       lt DataGridTextColumn Binding   Binding Path Mail   Header  E-mail   gt     lt  DataGrid Columns gt   lt  DataGrid gt    So I can access my SelectedContact Name in my ViewModel

User · Answer

An easy way that works   private void dataGrid SelectedCellsChanged object sender  SelectedCellsChangedEventArgs e        foreach  var item in e AddedCells                var col   item Column as DataGridColumn          var fc   col GetCellContent item Item            if  fc is CheckBox                        Debug WriteLine  Values     fc as CheckBox  IsChecked                     else if fc is TextBlock                        Debug WriteLine  Values     fc as TextBlock  Text                          Like this for all available types of cells

User · Answer

I believe the reason there s no straightforward property to access the selected row of a WPF DataGrid is because a DataGrid s selection mode can be set to either the row-level or the cell-level  Therefore  the selection-related properties and events are all written against cell-level selection - you ll always have selected cells regardless of the grid s selection mode  but you aren t guaranteed to have a selected row   I don t know precisely what you re trying to achieve by handling the CellEditEnding event  but to get the values of all selected cells when you select a row  take a look at handling the SelectedCellsChanged event  instead  Especially note the remarks in that article      You can handle the   SelectedCellsChanged event to be   notified when the collection of   selected cells is changed  If the   selection includes full rows  the   Selector SelectionChanged event is   also raised       You can retrieve the AddedCells and   RemovedCells from the   SelectedCellsChangedEventArgs in the   event handler    Hope that helps put you on the right track

User · Answer

After hours of finding ways on how to get the data from the row selected on a WPF DataGrid Control  as I was using MongoDB  I found this post and used Tony s answer  I revised the code to be relevant to my project  Maybe someone can use this to get an idea   private void selectionChanged object sender  SelectionChangedEventArgs e                facultyData row    facultyData facultyDataGrid SelectedItem          facultyID Textbox Text   row facultyID          lastName TextBox Text   row lastName          firstName TextBox Text   row firstName          middleName TextBox Text   row middleName          age TextBox Text   row age ToString              class facultyData       public ObjectId  id   get  set        public string facultyID   get  set        public string acadYear   get  set        public string program   get  set

User · Answer

I used a similar way to solve this problem using the animescm sugestion  indeed we can obtain the specific cells values from a group of selected cells using an auxiliar list   private void dataGridCase SelectionChanged object sender  SelectedCellsChangedEventArgs e                foreach  var item in e AddedCells                        var col   item Column as DataGridColumn              var fc   col GetCellContent item Item               lstTxns Items Add  fc as TextBlock  Text

User · Answer

Solution based on Tonys answer           DataGrid dg   sender as DataGrid          User row    User dg SelectedItems 0           Console WriteLine row UserID

[c#] DataGrid get selected rows' column values

Examples related to c#

Examples related to .net

Examples related to wpf

Examples related to datagrid