EF Core - VS2022 How to obtain DataGrid Column Value and insert it in TextBox

Question

Hi,
I'm using Visual Studio 2022, WPF, EF Core and C#.
I have a DataGrid that is working fine.
I select a line and I would like to put the columns of the selected line in a Grid on the same page each column value have to be put in a TextBox.
I have tried several codes found on the Web but none of these is working for me.
// 2dn attempt provide row but no access to defined column
DataGrid dataGrid = (DataGrid)sender;
var selected_row = dataGrid.SelectedItem;
TxBxUserCode1.Text = selected_row.ToString();

Most of the cases the selected_row is null. In the above example I have page.DbModel.Entity only.
Could someone send me some usefull links or example?
Thanks

Accepted Answer

Hi Dimitri,
try following demo. For details I use Grid with DataContext binded to SelectedItem of DataGrid.

xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"  
        xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"  
        xmlns:d="http://schemas.microsoft.com/expression/blend/2008"  
        xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"  
        xmlns:local="clr-namespace:WpfApp022"  
        mc:Ignorable="d"  
        Title="DimitriGarmaise-5522_20220530" Height="300" Width="400">  
    
      
    
      
      
        
        
      
      
        
          
          
          
        
        
          
          
        
        
        
        
        
      
      
    
  

using System.Collections.Generic;  
using System.ComponentModel;  
using System.Runtime.CompilerServices;  
using System.Windows;  
  
namespace WpfApp022  
{  
  public class ViewModel  
  {  
    // Load Data  
    public ViewModel() { for (int i = 1; i < 100; i++) View.Add(new Data() { Codic = i, Nome = $"Nome {i}" }); }  
    public List View { get; set; } = new List();  
  }  
}

Result:

Answer

Reference documentation：Getting Started with WPF

Add the NuGet Packages:

Microsoft.EntityFrameworkCore.Sqlite
Microsoft.Extensions.DependencyInjection

App.xaml:

App.xaml.cs:

using Microsoft.EntityFrameworkCore;  
using Microsoft.Extensions.DependencyInjection;  
using System.Windows;  

namespace WpfApp1  
{  
  public partial class App : Application  
  {  
    private readonly ServiceProvider serviceProvider;  
    public App()  
    {  
      ServiceCollection services = new ServiceCollection();  
      services.AddDbContext(options =>  
      {  
        options.UseSqlite("Data Source = Product.db");  
      });  
      services.AddSingleton();  
      serviceProvider = services.BuildServiceProvider();  
    }  
    private void OnStartup(object s, StartupEventArgs e)  
    {  
      var mainWindow = serviceProvider.GetService();  
      mainWindow.Show();  
    }  
  }  
}

MainWindow.xaml:

MainWindow.xaml.cs:

using Microsoft.EntityFrameworkCore;  
using System.ComponentModel;  
using System.Linq;  
using System.Runtime.CompilerServices;  
using System.Windows;  

namespace WpfApp1  
{  
  public partial class MainWindow : Window  
  {  
    ProductDbContext context;  
    Product NewProduct = new Product();  
    Product selectedProduct = new Product();  

    public MainWindow(ProductDbContext context)  
    {  
      this.context = context;  
      InitializeComponent();  
      GetProducts();  
      NewProductGrid.DataContext = NewProduct;  
    }  
    private void GetProducts()  
    {  
      ProductDG.ItemsSource = context.Products.ToList();  
    }  
    private void AddItem(object s, RoutedEventArgs e)  
    {  
      context.Products.Add(NewProduct);  
      context.SaveChanges();  
      GetProducts();  
      NewProduct = new Product();  
      NewProductGrid.DataContext = NewProduct;  
    }  
    private void UpdateItem(object s, RoutedEventArgs e)  
    {  
      context.SaveChanges();  
      GetProducts();  
    }  
    private void DeleteProduct(object s, RoutedEventArgs e)  
    {  
      var productToDelete = (s as FrameworkElement).DataContext as Product;  
      context.Products.Remove(productToDelete);  
      context.SaveChanges();  
      GetProducts();  
    }  
    private void SelectProductToEdit(object s, RoutedEventArgs e)  
    {  
      selectedProduct = (s as FrameworkElement).DataContext as Product;  
      UpdateProductGrid.DataContext = selectedProduct;  
    }  
  }  
  public class Product  
  {  
    public int Id { get; set; }  
    public string Name { get; set; }  
    public string Description { get; set; }  
    public double Price { get; set; }  
    public int Unit { get; set; }  
  }  
  public class ProductDbContext : DbContext, INotifyPropertyChanged  
  {  
    public ProductDbContext(DbContextOptions options) : base(options)  
    {  
      Database.EnsureCreated();  
    }  
    public DbSet Products { get; set; }  

    protected override void OnModelCreating(ModelBuilder modelBuilder)  
    {  
      modelBuilder.Entity().HasData(GetProducts());  
      base.OnModelCreating(modelBuilder);  
    }  
    private Product selectedProduct;  
    public Product SelectedProduct { get { return selectedProduct;}set{ selectedProduct=value; OnPropertyChanged("SelectedProduct");} }  
    public event PropertyChangedEventHandler PropertyChanged;  
    internal void OnPropertyChanged([CallerMemberName] string propName = "") => PropertyChanged?.Invoke(this, new PropertyChangedEventArgs(propName));  

    private Product[] GetProducts()  
    {  
      return new Product[]  
      {  
            new Product { Id = 1, Name = "TShirt", Description = "Blue Color", Price = 2.99, Unit =1},  
            new Product { Id = 2, Name = "Shirt", Description = "Formal Shirt", Price = 12.99, Unit =1},  
            new Product { Id = 3, Name = "Socks", Description = "Wollen", Price = 5.00, Unit =2},  
            new Product { Id = 4, Name = "Tshirt", Description = "Red", Price = 2.99, Unit =3},  
      };  
    }  

  }  
}

The result:

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our [documentation][5] to enable e-mail notifications if you want to receive the related email notification for this thread.

[5]: https://learn.microsoft.com/en-us/answers/articles/67444/email-notifications.html

EF Core - VS2022 How to obtain DataGrid Column Value and insert it in TextBox

1 additional answer