WPF DataGrid: How to Determine the Current Row Ind

Question

I am trying to implement a very simple spreadsheet functionality based on a DataGrid.

1. The user clicks on a cell

2. The user types a value and presses return

3. The current row is scanned and any cell formula that depends on the clicked cell is updated.

This seems to be the best event handler for my requirements:

private void my_dataGrid_CurrentCellChanged(object sender, EventArgs e)

Question: How do I detect the row index of the current row?

Answer 1

1.When click on the Cell inside the Datagrid, Get the CurrentCell info

2.From the DatagridCellInfo, we can find Column and Row index of particular cell

private void CellClick(object sender,RoutedEventArgs e)
    {
     DataGridCellInfo cell=DataGrid.CurrentCell;
     int columnindex=cell.Column.DisplayIndex;
     int rowIndex=DataGrid.Items.IndexOf(cell.Item);
    }

Answer 2

The accepted solution will work until you have no reference-duplicates in the ItemsSource, otherwise you will get index of the object's first occurrence.

The solution from BRAHIM Kamel will work until you have a selection, otherwise(if you click twice and deselect a cell/row) you will not have a SelectedIndex.

With YourDataGrid.ItemContainerGenerator.ContainerFromItem( _dataItemFromCurentCell ) as DataGridRow you will get by duplicates always the last occurrence of data item.

I would handle DataGrid.PreviewMouseLeftButtonDown event and search in handler the visual tree up to a DatagridRow, which has DatagridRow.GetIndex() method. So you will get always the right row index.

<DataGrid ... PreviewMouseLeftButtonDown="Previe_Mouse_LBtnDown" >
    ...
</DataGrid>

private void Previe_Mouse_LBtnDown(object sender, MouseButtonEventArgs e)
{
    DataGridRow dgr = null;
    var visParent = VisualTreeHelper.GetParent(e.OriginalSource as FrameworkElement);
    while (dgr == null && visParent != null)
    {
        dgr = visParent as DataGridRow;
        visParent = VisualTreeHelper.GetParent(visParent);
    }
    if (dgr == null) { return; }

    var rowIdx=dgr.GetIndex();
}

Answer 3

Try this (assuming the name of your grid is "my_dataGrid"):

var currentRowIndex = my_dataGrid.Items.IndexOf(my_dataGrid.CurrentItem);

Normally, you'd be able to use my_dataGrid.SelectedIndex, but it seems that with the CurrentCellChanged event, the value of SelectedIndex always displays the previously selected index. This particular event seems to fire before the value of SelectedIndex actually changes.

Answer 4

Hi you can do something like this to do your spreadsheed

 //not recomended  as it always  return the previous index of the selected row 
 void dg1_CurrentCellChanged(object sender, EventArgs e)
    {

       int rowIndex = dg1.SelectedIndex;   
     }

but if you want a more elaborated example this is how you can do it

namespace WpfApplication2
{
/// <summary>
/// Interaction logic for MainWindow.xaml
/// </summary>
public partial class MainWindow : Window
{
    ObservableCollection<Tuple<string,string>> observableCollection = new ObservableCollection<Tuple<string,string>>();  
    public MainWindow()
    {
        InitializeComponent();            
        for (int i = 0; i < 100; i++)
        {
            observableCollection.Add( Tuple.Create("item " + i.ToString(),"=sum (c5+c4)"));
        }

        dg1.ItemsSource = observableCollection; 

        dg1.CurrentCellChanged += dg1_CurrentCellChanged;

    }

    void dg1_CurrentCellChanged(object sender, EventArgs e)
    {
        //int rowIndex = dg1.SelectedIndex;   
        Tuple<string, string> tuple = dg1.CurrentItem as Tuple<string, string>; 
        //here as you have your datacontext you can loop through and calculate what you want 

    }
}
}

Hope this help

Answer 5

GRD.Items.Count;
DataGridRow row = (DataGridRow) GRD.ItemContainerGenerator.ContainerFromIndex(i);     
DataGridCell TXTGROUPID = GRD.Columns[2].GetCellContent(row).Parent as DataGridCell;               
string str = ((TextBlock) TXTGROUPID.Content).Text;
MessageBox.Show(str);