XAML DataGrid更新没有';t更新数据库
本文关键字:更新 数据库 DataGrid XAML | 更新日期: 2024-09-25 08:46:15
我正在尝试在RowEditEnding事件上从XAML DataGrid更新数据库记录数据库名称:ManageOrders表:客户:ID(Guid)、名称(varchar)、地址(varchar数据库设置为:如果更新则复制数据集设置为:不复制
如果我使用UPDATE和ExecuteNonQuery对查询进行硬编码,我会得到结果,但当我尝试使用datasets/dataTableAdapter.UPDATE时,它不会更新。请帮忙。注意,我对WPF和C#编程非常陌生。我花了一周的时间研究这个问题,但找不到答案或自己解决。
这是我的代码
public partial class MainWindow : Window
{
public MainWindow()
{
InitializeComponent();
}
private SimpleData.ManageOrdersDataSet manageOrdersDataSet;
private SimpleData.ManageOrdersDataSetTableAdapters.CustomerTableAdapter manageOrdersDataSetCustomerTableAdapter;
System.Windows.Data.CollectionViewSource customerViewSource;
private void Window_Loaded(object sender, RoutedEventArgs e)
{
manageOrdersDataSet = ((SimpleData.ManageOrdersDataSet)(this.FindResource("manageOrdersDataSet")));
// Load data into the table Customer. You can modify this code as needed.
manageOrdersDataSetCustomerTableAdapter = new SimpleData.ManageOrdersDataSetTableAdapters.CustomerTableAdapter();
manageOrdersDataSetCustomerTableAdapter.Fill(manageOrdersDataSet.Customer);
customerViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("customerViewSource")));
customerViewSource.View.MoveCurrentToFirst();
}
private void customerDataGrid_RowEditEnding(object sender, DataGridRowEditEndingEventArgs e)
{
this.manageOrdersDataSetCustomerTableAdapter.Update(this.manageOrdersDataSet.Customer);
manageOrdersDataSet.AcceptChanges();
}
}
这是我的XAML
<Window
xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
xmlns:local="clr-namespace:SimpleData" x:Class="SimpleData.MainWindow"
Title="MainWindow" Height="350" Width="525" Loaded="Window_Loaded">
<Window.Resources>
<local:ManageOrdersDataSet x:Key="manageOrdersDataSet"/>
<CollectionViewSource x:Key="customerViewSource" Source="{Binding Customer, Source={StaticResource manageOrdersDataSet}}"/>
</Window.Resources>
<Grid>
<Grid.ColumnDefinitions>
<ColumnDefinition Width="533*"/>
<ColumnDefinition Width="186*"/>
</Grid.ColumnDefinitions>
<Grid.RowDefinitions>
<RowDefinition Height="43*"/>
<RowDefinition Height="377*"/>
</Grid.RowDefinitions>
<TabControl Grid.Column="0" HorizontalAlignment="Left" Height="357" Margin="10,9.8,0,0" Grid.Row="1" VerticalAlignment="Top" Width="513">
<TabItem x:Name="tabView" Header="Customer">
<Grid DataContext="{StaticResource customerViewSource}">
<DataGrid x:Name="customerDataGrid" RowDetailsVisibilityMode="VisibleWhenSelected" Margin="0,0,137,75" ItemsSource="{Binding}" EnableRowVirtualization="True" AutoGenerateColumns="False" RowEditEnding="customerDataGrid_RowEditEnding" >
<DataGrid.Columns>
<DataGridTextColumn x:Name="iDColumn" Width="10" Header="ID" Binding="{Binding ID, UpdateSourceTrigger=PropertyChanged, NotifyOnTargetUpdated=True, Mode=TwoWay }"/>
<DataGridTextColumn x:Name="nameColumn" Width="*" Header="Name" Binding="{Binding Name, UpdateSourceTrigger=PropertyChanged, NotifyOnTargetUpdated=True, Mode=TwoWay }"/>
<DataGridTextColumn x:Name="addressColumn" Width="*" Header="Address" Binding="{Binding Address, UpdateSourceTrigger=PropertyChanged, NotifyOnTargetUpdated=True, Mode=TwoWay}"/>
</DataGrid.Columns>
</DataGrid>
</Grid>
</TabItem>
<TabItem Header="Order">
<Grid Background="#FFE5E5E5" Width="auto"/>
</TabItem>
</TabControl>
</Grid>
我找到了问题的答案。当我创建数据库时,我忘记设置PRIMARY KEY。我的意思是,我没有转到属性并选择字段-主键(在MSSQL管理器中,表的设计)如果不设置Visual studio无法正确生成UPDATE命令
为了验证我是否转到(右键单击)TABLE ADAPTER->CONFIGURE->ADVANCE OPTIONS并检查REFRESH THE DATA TABLE是否打开。
希望有一天这会对某人有所帮助。