Pfthb

I searched several times about datagrid refresh problem. But can't get any idea about it. My problem is as below. Bascially it can work.
But if user sort columns and then edit cell, datagrid can't bind. VS would list error ""Once AddNew or EditItem not allow “Sorting”。"."

But it's friendly for user to be allowed to sort datagrid columns. Please help me to address this problem.Thanks!

private void DataGrid1_CellEditEnding(object sender, DataGridCellEditEndingEventArgs e)
 

 string sql="update table1 set field1='"+cell_value+''
 BindGR();

 


 private void BindGR()

 
 //Bind DataGrid
 if (dt != null)
 
 DataGrid1.ItemsSource = dt.DefaultView;

 

 

View.xaml

 <DataGrid x:Name="MyDataGrid" 
 Sorting="DataGrid_OnSorting" 
 ItemsSource="Binding DataGridItems, Mode="TwoWay"">
 </DataGrid>

View.xaml.cs

 private ObservableCollection<DataClass> dataGridItems = new ObservableCollection<DataClass>();

 public ObservableCollection<DataClass> DataGridItems
 
 get return dataGridItems; 
 set SetProperty(ref dataGridItems, value); 
 

Please try with TwoWay binding ie Mode="TwoWay" for Itemssource

If it doesn't work, try code below. I did not test the code, since it is not fully implemented. Try to get an idea from this!

private void DataGrid_OnSorting(object sender, DataGridSortingEventArgs e)

 var sortedGrid = sender as DataGrid;
 foreach (var item in sortedGrid.Items)
 
 DataGridItems.Add(item);
 

Item source update on RowEditEnding event. use RowEditEnding event instead of CellEndEditing and on the column binding use UpdateSourceTrigger=LostFocus.

<DataGridTextColumn Binding="Binding bindedProperty,StringFormat=n0 , Mode=TwoWay , UpdateSourceTrigger=LostFocus"></DataGridTextColumn>