Re: Grid update a DataTable?

Ted — Tue, 07 Apr 2009 00:26:10 GMT

Of course! Yikes! I forgot about RowState, etc. Thank you very much!

-Ted

Re: Grid update a DataTable?

Jenny [Xceed] — Mon, 06 Apr 2009 12:24:50 GMT

You should update the TableAdapter by calling its Update method and the accept the changes on the DataTable using its AcceptChanges method.

Grid update a DataTable?

Ted — Mon, 06 Apr 2009 03:06:52 GMT

I am using your WPF datagrid with it bound to a .NET DataTable.
I am trying to implement deleting rows that have been selected
in the grid and have the resulting source DataTable contents
reflect the change (i.e. the source DataTable should not
then contain the deleted DataRows.)

However, after deleting the rows in the grid, the rows remain
in the bound DataTable.

What must I do to have the bound DataTable updated (rows deleted)?

The code snippets are below.

Thanks,
Ted

----------------------------------------------------------------------------------------------------------------------------
Here is the XAML for the datagrid:

<xcdg:DataGridControl Grid.Row="2" Grid.ColumnSpan="6" Name="TableDataGrid"
                         xmlns:xcdg="http://schemas.xceed.com/wpf/xaml/datagrid"
                         ReadOnly="False" Grid.RowSpan="2"
                         IsDeleteCommandEnabled="True"
                         DeletingSelectedItems="DataGrid_DeletingSelectedItems"
                         DeletingSelectedItemError="DataGrid_DeletingSelectedItemsError"
                         SelectedItemsDeleted="Grid_SelectedItemsDeleted">
            <xcdg:DataGridControl.View>
                <xcdg:TableView>
                    <xcdg:TableView.Theme>
                        <xcdg:AeroNormalColorTheme />
                    </xcdg:TableView.Theme>
                </xcdg:TableView>
            </xcdg:DataGridControl.View>
        </xcdg:DataGridControl>

----------------------------------------------------------------------------------------------------------------------

// Here is the code setting up the grid with the DataTable:

// setup binding for DataGrid
TableDataGrid.ItemsSource =

new DataGridCollectionView(dsvEODequityList.ViewEODequityList.DefaultView);

//The C# handlers are below. They are essentially copied from
//your online examples:

private void DataGrid_DeletingSelectedItemsError(
                                    object sender,
        DeletingSelectedItemErrorRoutedEventArgs e)
{
    MessageBoxResult result =
                   System.Windows.MessageBox.Show(                                                                                      "The following error occurred " +
             "while attempting to delete an item: " +
                                e.Exception.Message +
              " Do you want to attempt to continue?",
                                             "Error",
                        MessageBoxButton.YesNoCancel);

   // If "No", the item would be skipped. Since "Skip" is the default action,
   // there is no need to verify it.
   if (result == MessageBoxResult.Yes)
   {
     if (this.TableDataGrid.IsBeingEdited)
        {
          try
          {
              this.TableDataGrid.CancelEdit();
              e.Action = DeletingSelectedItemErrorAction.Retry;
          }
          catch
          {
              e.Action = DeletingSelectedItemErrorAction.Skip;
          }
        }
    }
    if (result == MessageBoxResult.Cancel)
    {
       e.Action = DeletingSelectedItemErrorAction.Abort;
    }
}

private void DataGrid_DeletingSelectedItems(object sender,
                                   CancelRoutedEventArgs e)
{
    MessageBoxResult result = System.Windows.MessageBox.Show(
             "Are you certain you want to delete the selected rows?",
                           "Confirm Delete", MessageBoxButton.YesNo);

    if (result == MessageBoxResult.No)
    {
       e.Cancel = true;
    }
}

Xceed DataGrid for WPF

Re: Grid update a DataTable?

Re: Grid update a DataTable?

Grid update a DataTable?