WPF. Table​Adapter​Manager.​UpdateAll NO WORK when DataSet is changed?

Hello Pgrogramms!

simple example, DataSet - UsersDataSet.xsd, table in DB - Users. In table some fields: id, firstname, lastname, job, etc.

In the interface some fields for editing and a list of which are filled with data from UsersDataSet.

When you change the data in the field and try to save, get:

System.InvalidOperationException: Update requires a valid UpdateCommand when passed DataRow collection with modified rows. at WPF1.UsersDataSetTableAdapters.TableAdapterManager.UpdateAll(UsersDataSet dataSet) in UsersDataSet.Designer.cs:line 1259 at WPF1.Window1.btnSave_Click(Object sender, RoutedEventArgs e) in Window1.xaml.cs:line 82

<ListBox ItemsSource="{Binding Path={}}" IsSynchronizedWithCurrentItem="True">

   <ListBox.ItemTemplate>

      <DataTemplate>

         <StackPanel Orientation="Horizontal">

            <Label Content="{Binding Path=Firstname}"></Label>

            <Label Content="{Binding Path=Lastname}"></Label>

         </StackPanel>

      </DataTemplate>

   </ListBox.ItemTemplate>

</ListBox>

<StackPanel>

   <TextBox Height="28" Name="txtUserID" Width="Auto" IsReadOnly="True" Text="{Binding Path=Id, Mode=OneWay}"/>

   <TextBox Height="28" Name="txtFirstName" Width="Auto" Text="{Binding Path=Firstname}"/>

   <TextBox Height="28" Name="txtLastName" Width="Auto" Text="{Binding Path=Lastname}"/>

<Button Name="btnSave" Width="65" Height="24" Click="btnSave_Click">Save</Button>

*.cs file:

private UsersDataSetTableAdapters.UsersTableAdapter taUsers = new UsersDataSetTableAdapters.UsersTableAdapter();

private UsersDataSet dsUsers = new UsersDataSet();

private UsersDataSetTableAdapters.TableAdapterManager taManager = new UsersDataSetTableAdapters.TableAdapterManager();

private CollectionView View;

private void Window_Loaded(object sender, RoutedEventArgs e)

{

taUsers.Fill(dsUsers.Users);

taManager.UsersTableAdapter = taUsers;

DataContext = from user in dsUsers.Users orderby user.Lastname select user; // ну или так DataContext = dsUsers.Users;

this.View = (CollectionView)(CollectionViewSource.GetDefaultView(this.dsUsers.Users));

}

private void btnSave_Click(object sender, RoutedEventArgs e)

{

   try  {   if (dsUsers.HasChanges()) { if ((taManager.UpdateAll(dsUsers) > 0)) { MessageBox.Show("Saved."); }  }   }

   catch (Exception ex) { MessageBox.Show(ex.ToString()); }

}

This has nothing to do with WPF - your table adapter has no update command.

jh71283 said:

This has nothing to do with WPF - your table adapter has no update command.

This usually occurs if you have not set a primary key on that table in the database.

Create a primary key, then re-create the datatable.

jh71283 said:

This has nothing to do with WPF - your table adapter has no update command.

This usually occurs if you have not set a primary key on that table in the database.

Create a primary key, then re-create the datatable.

thank you