unable to get a TextBlock Binding to connect to a backing Db Class Property in WPF

Question

I am using VS2019 to develop a program using the NorthWind Db, basically to learn/improve my C# skills. I am not an expert by any means although I have used "C" in various forms for a great many years

I have a window with multiple DataGrids, each bound to a different Db backing class, which bind just fine, and each has a header line with total records, current record etc above it.

My problem is that my XAML will NOT read the data from the background class, although debugging show it updating the values with the Setter as expected, but the getter is never called

To clarify the scenario, the current setup is :

XAML file :-

The above have no errors at all on them, so are presumably correct..
It is the Nwcustomer class that has the CustomerCurrent property that is giving me the problem.

The offending control is :

There are no apparent errors in the above, and hovering over the CustomerCurrent shows it identified as an int32, which is correct

I have even tried removing the Propertychanged from the binding. Still no change in operation.

When debugging the App The CustomersCurrent Property Setter is triggered by the line :

nwcustomer . CustomerCurrent = CustomersGrid . SelectedIndex; in the Cs file

and if I use CustomerCurrent to set the .Text field after the values are set in the CS file, it works correctly, and the GETTER is called as expected.

It is just that the TextBlock will NOT do it in XAML, although filling the TextBox field in Code Behind works perfectly.

I have tried it in another similar but separate window with the same non result.
This is driving me crazy, I have a couple of other similar fields, all are having the same issue.

Answer

How do you bind the data of the database table to the DataGrid? If I am not misunderstood, you want to bind the selected index to the TextBlock. I use the following code to display the selected index in the TextBlock. And getter can get the changed value. Could you try to use the following code in your project. If I misunderstood, please let me know.
The code of MainWindow. Xaml:

The code of MainWindow. Xaml.cs:

public partial class MainWindow : Window,INotifyPropertyChanged  
  {  
    public MainWindow()  
    {  
      InitializeComponent();  
      FillGrid();  
    }  
    private void FillGrid()  
    {  
      string constr = @"constr ";  
      SqlConnection con = new SqlConnection(constr);  
      con.Open();  
      SqlCommand cmd = new SqlCommand("Select * From [dbo].[Customers]", con);  
      SqlDataAdapter da = new SqlDataAdapter(cmd);  
      var dt = new DataTable();  
      da.Fill(dt);  
      dataGrid.ItemsSource = dt.DefaultView;  
      con.Close();  
    }  
    private int customerCurrent;   
    public int CustomerCurrent  
    {  
      get  
      {  
        return customerCurrent;  
      }  
      set  
      {  
        customerCurrent = value;  
        OnPropertyChange("CustomerCurrent");  
      }  
   }  
    public event PropertyChangedEventHandler PropertyChanged;  
    protected void OnPropertyChange(string propertyName)  
    {  
      PropertyChangedEventHandler handler = this.PropertyChanged;  
      if (handler != null)  
      {  
        var e = new PropertyChangedEventArgs(propertyName);  
        handler(this, e);  
       }     
}  
    private void dataGrid_SelectedCellsChanged(object sender, SelectedCellsChangedEventArgs e)  
    {  
      int select= dataGrid.SelectedIndex;  
      customerCurrent = select;  
      tb.Text = customerCurrent.ToString();   
    }   
  }

The result picture:

Update:

Your CustomerCurrent is actually binding the SelectedIndex of the DataGrid to the Textblock. You could bind SelectedIndex directly in xaml. The code here is used to bind TextBlock directly to SelectedIndex.

The code of MainWindow. Xaml:

The code of MainWindow. Xaml.cs:

public partial class MainWindow : Window,INotifyPropertyChanged  
  {  
    public MainWindow()  
    {  
      InitializeComponent();  
       
      FillGrid();  
    }  
    private void FillGrid()  
    {  
      string constr = @"constr ";  
      SqlConnection con = new SqlConnection(constr);  
      con.Open();  
      SqlCommand cmd = new SqlCommand("Select * From [dbo].[Customers]", con);  
      SqlDataAdapter da = new SqlDataAdapter(cmd);  
      var dt = new DataTable();  
      da.Fill(dt);  
      dataGrid.ItemsSource = dt.DefaultView;  
      List SelectedIndexs = dataGrid.SelectedItems  
        .Cast()  
        .Select(view => dt.Rows.IndexOf(view.Row))  
        .ToList();  
      con.Close();  
    }  
  
    public event PropertyChangedEventHandler PropertyChanged;  
    protected void OnPropertyChange(string propertyName)  
    {  
      PropertyChangedEventHandler handler = this.PropertyChanged;  
      if (handler != null)  
      {  
        var e = new PropertyChangedEventArgs(propertyName);  
        handler(this, e);  
      }  
    }  
  }

The result picture:

Answer

Thanks for that response, but you have actually sidestepped, or missed the major problem !
You use the line :

tb.Text = customerCurrent.ToString();

in code behind to set the text field, which I could do already. My problem is that I do NOT want to do it in c# code, I want the binding in XAML to handle it automatically?

Does that make sense ?

Share via

unable to get a TextBlock Binding to connect to a backing Db Class Property in WPF

2 answers