Complete Guide to Retrieving Selected Row Column Values in WPF DataGrid

Core Concepts of DataGrid Selected Row Data Access

In WPF application development, the DataGrid control is a commonly used component for displaying and editing tabular data. However, many developers encounter difficulties when attempting to access column values of selected rows. This article systematically introduces several effective methods and provides an in-depth analysis of their underlying principles.

Accessing Row Data Using SelectedItems Property

The SelectedItems property of the DataGrid control returns a collection containing all selected items. This is one of the most straightforward methods for accessing selected row data. When the DataGrid is bound to a data source, each selected item typically corresponds to an object in that data source.

The following code demonstrates how to retrieve data from selected rows:

IList rows = dataGrid1.SelectedItems;
foreach (var row in rows)
{
    // Assuming the data object type is User
    User user = row as User;
    if (user != null)
    {
        Console.WriteLine($"UserID: {user.UserID}, UserName: {user.UserName}");
    }
}

The key to this approach lies in understanding the DataGrid's data binding mechanism. When DataGrid columns are bound to properties of data objects through the Binding attribute, selected items directly correspond to these data objects.

Accessing Specific Column Values Through DataRowView

In certain scenarios, particularly when the DataGrid is bound to a DataTable, selected items may be DataRowView objects. In such cases, specific column values can be accessed by column name or index.

Here is example code using DataRowView:

if (dataGrid1.SelectedItems.Count > 0)
{
    DataRowView rowView = dataGrid1.SelectedItems[0] as DataRowView;
    if (rowView != null)
    {
        string userID = rowView["UserID"].ToString();
        string userName = rowView["UserName"].ToString();
        Console.WriteLine($"UserID: {userID}, UserName: {userName}");
    }
}

This method is suitable for dynamic data scenarios but requires attention to type conversion safety.

Handling Multiple Row Selection and Cell Editing

In practical applications, users may select multiple rows or edit data directly in cells. Within the CellEditEnding event, data from the cell being edited can be accessed through the DataGridCellEditEndingEventArgs parameter.

An improved CellEditEnding event handler is shown below:

private void dataGrid1_CellEditEnding(object sender, DataGridCellEditEndingEventArgs e)
{
    if (e.EditAction == DataGridEditAction.Commit)
    {
        var cell = e.Column.GetCellContent(e.Row);
        if (cell is TextBlock textBlock)
        {
            Console.WriteLine($"Cell value: {textBlock.Text}");
        }
        else if (cell is TextBox textBox)
        {
            Console.WriteLine($"Cell value: {textBox.Text}");
        }
    }
}

This approach captures the latest values after user edits but requires attention to the timing of event triggering.

Performance Optimization and Best Practices

When dealing with large datasets, frequent access to DataGrid selected items may impact performance. Recommendations include:

1. Retrieve selected data only when necessary, avoiding complex operations in frequently triggered events
2. Use Dispatcher to ensure UI thread safety
3. Implement safety checks for potentially null references
4. Consider using the MVVM pattern, binding properties rather than directly manipulating UI elements

By understanding the DataGrid's data binding mechanism and selecting appropriate access methods, developers can efficiently handle tabular data and enhance the user experience of their applications.