Hi Micha,
hier mal eine Demo für einen der möglichen Lösungswege.
XAML:
<Window x:Class="WpfApp1.Window61"
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:WpfApp1"
mc:Ignorable="d"
Title="Window61" Height="450" Width="800">
<Window.Resources>
<local:Window61VM x:Key="vm"/>
</Window.Resources>
<Grid DataContext="{StaticResource vm}">
<Grid.RowDefinitions>
<RowDefinition/>
<RowDefinition Height="Auto"/>
</Grid.RowDefinitions>
<Grid.ColumnDefinitions>
<ColumnDefinition/>
<ColumnDefinition/>
</Grid.ColumnDefinitions>
<ListBox ItemsSource="{Binding View}" DisplayMemberPath="Info"/>
<Grid Grid.Column="1" DataContext="{Binding Detail}">
<Grid.Resources>
<Style TargetType="Label">
<Setter Property="HorizontalAlignment" Value="Right"/>
</Style>
</Grid.Resources>
<Grid.RowDefinitions>
<RowDefinition Height="auto"/>
<RowDefinition Height="auto"/>
<RowDefinition Height="auto"/>
<RowDefinition Height="auto"/>
<RowDefinition Height="auto"/>
<RowDefinition/>
</Grid.RowDefinitions>
<Grid.ColumnDefinitions>
<ColumnDefinition Width="auto"/>
<ColumnDefinition/>
</Grid.ColumnDefinitions>
<Label Content="Detail" Grid.ColumnSpan="2" HorizontalAlignment="Center"/>
<Label Content="ID" Grid.Row="1"/>
<Label Content="{Binding ID}" Grid.Row="1" Grid.Column="1"/>
<Label Content="Info" Grid.Row="2"/>
<TextBox Text="{Binding Info}" Grid.Row="2" Grid.Column="1"/>
</Grid>
<StackPanel Grid.Column="1" Grid.Row="1"
Orientation="Horizontal" HorizontalAlignment="Right">
<StackPanel.Resources>
<Style TargetType="Button">
<Setter Property="Margin" Value="5"/>
</Style>
</StackPanel.Resources>
<Button Content="Laden" Command="{Binding Cmd}" CommandParameter="load"/>
<Button Content="Hinzufügen" Command="{Binding Cmd}" CommandParameter="new"/>
<Button Content="Löschen" Command="{Binding Cmd}" CommandParameter="del"/>
<Button Content="Speichern" Command="{Binding Cmd}" CommandParameter="save"/>
</StackPanel>
</Grid>
</Window>
Dazu alle Klassen:
using System.ComponentModel;
using System.Data;
using System.Runtime.CompilerServices;
using System.Windows;
using System.Windows.Data;
using System.Windows.Input;
namespace WpfApp1
{
public class Window61VM : INotifyPropertyChanged
{
// Model-Instanz beim Instanziieren des ViewModels erzeugen
Window61Mod model = new Window61Mod();
// Quelle für die Sicht auf die Liste der Daten
CollectionViewSource cvs = new CollectionViewSource();
// Sicht-Eigenschaft zur Bindung an die ListrBox
public ICollectionView View { get => cvs.View; }
/// <summary>
/// Eigenschaft für Command-Bindung
/// </summary>
public ICommand Cmd { get { return new RelayCommand(CmdExec, CmdCanExec); } }
/// <summary>
/// Methode, die bei Command-Auslösung abgearbeitet wird
/// </summary>
/// <param name="obj">CommandParameter</param>
private void CmdExec(object obj)
{
switch (obj.ToString())
{
case "load":
cvs.Source = model.GetData();
cvs.View.CurrentChanged += (o, ev) =>
{
Detail = cvs.View.CurrentItem;
OnPropertyChanged(nameof(Detail));
};
OnPropertyChanged(nameof(View));
OnPropertyChanged(nameof(Cmd));
break;
case "new":
Detail = model.InsertNewRow();
OnPropertyChanged(nameof(Detail));
break;
case "del":
model.DeleteRow(Detail);
break;
case "save":
model.Save();
object det = Detail;
Detail = null;
OnPropertyChanged(nameof(Detail));
Detail = det;
OnPropertyChanged(nameof(Detail));
OnPropertyChanged(nameof(View));
break;
default:
break;
}
}
private bool CmdCanExec(object obj)
{
switch (obj.ToString())
{
case "load":
return true;
case "new":
case "del":
case "save":
return cvs.Source != null;
default:
break;
}
return true;
}
public object Detail { get; set; }
#region OnPropertyChanged
public event PropertyChangedEventHandler PropertyChanged;
private void OnPropertyChanged([CallerMemberName] string propName = "") =>
PropertyChanged?.Invoke(this, new PropertyChangedEventArgs(propName));
#endregion
}
public class Window61Mod
{
private Window61DataSet.Window61DBTab1DataTable dt = new Window61DataSet.Window61DBTab1DataTable();
internal DataTable GetData()
{
using (Window61DataSetTableAdapters.Window61DBTab1TableAdapter ta = new Window61DataSetTableAdapters.Window61DBTab1TableAdapter())
{
ta.Fill(dt);
}
return dt;
}
internal DataRow InsertNewRow()
{
Window61DataSet.Window61DBTab1Row row = dt.NewWindow61DBTab1Row();
row.Info = "neu";
dt.Rows.Add(row);
return row;
}
internal void DeleteRow(object detail)
{
DataRowView drv = detail as DataRowView;
if (drv == null)
{
DataRow r = detail as DataRow;
r?.Delete();
}
else drv.Row.Delete();
}
internal void Save()
{
using (Window61DataSetTableAdapters.Window61DBTab1TableAdapter ta = new Window61DataSetTableAdapters.Window61DBTab1TableAdapter())
{
ta.Adapter.RowUpdated += (object sender, System.Data.OleDb.OleDbRowUpdatedEventArgs e) =>
{
if (e.StatementType == StatementType.Insert)
{
int newID = 0;
System.Data.OleDb.OleDbCommand idCmd = new System.Data.OleDb.OleDbCommand("SELECT @@IDENTITY", e.Command.Connection);
newID = (int)(idCmd.ExecuteScalar());
foreach (DataColumn col in e.Row.Table.Columns)
{
if (col.AutoIncrement)
{
e.Row[col.ColumnName] = newID;
return;
}
}
}
};
ta.Update(dt);
}
}
}
}
--
Viele Grüsse
Peter Fleischer (ehem. MVP für Developer Technologies)
Meine Homepage mit Tipps und Tricks
