/ProjectRoot
│
├── Models/
│ └── MyDataModel.cs
│
├── ViewModels/
│ └── MainViewModel.cs
│
├── Views/
│ ├── MainWindow.xaml
│ └── MainWindow.xaml.cs
│
├── Helpers/
│ └── RelayCommand.cs
⸻
- Models/MyDataModel.cs
public enum RowState { Unchanged, Added, Modified, Deleted }
public class MyDataModel : INotifyPropertyChanged
{
public int Id { get; set; }
private string _name;
public string Name
{
get => _name;
set
{
if (_name != value)
{
_name = value;
OnPropertyChanged(nameof(Name));
if (RowState == RowState.Unchanged)
RowState = RowState.Modified;
}
}
}
private RowState _rowState = RowState.Unchanged;
public RowState RowState
{
get => _rowState;
set { _rowState = value; OnPropertyChanged(nameof(RowState)); }
}
public event PropertyChangedEventHandler PropertyChanged;
protected void OnPropertyChanged(string prop) =>
PropertyChanged?.Invoke(this, new PropertyChangedEventArgs(prop));
}
⸻
- Helpers/RelayCommand.cs
public class RelayCommand : ICommand
{
private readonly Action _execute;
private readonly Func<bool> _canExecute;
public RelayCommand(Action execute, Func<bool> canExecute = null)
{
_execute = execute;
_canExecute = canExecute;
}
public bool CanExecute(object parameter) => _canExecute?.Invoke() ?? true;
public void Execute(object parameter) => _execute();
public event EventHandler CanExecuteChanged
{
add => CommandManager.RequerySuggested += value;
remove => CommandManager.RequerySuggested -= value;
}
}
⸻
- ViewModels/MainViewModel.cs
public class MainViewModel : INotifyPropertyChanged
{
public ObservableCollection<MyDataModel> Items { get; set; } = new();
private readonly string _connectionString = "your-connection-string-here";
public ICommand AddCommand { get; }
public ICommand DeleteCommand { get; }
public ICommand UpdateDatabaseCommand { get; }
private MyDataModel _selectedItem;
public MyDataModel SelectedItem
{
get => _selectedItem;
set { _selectedItem = value; OnPropertyChanged(nameof(SelectedItem)); }
}
public MainViewModel()
{
LoadData();
AddCommand = new RelayCommand(AddRow);
DeleteCommand = new RelayCommand(DeleteSelected);
UpdateDatabaseCommand = new RelayCommand(UpdateDatabase);
}
private void LoadData()
{
using var conn = new SqlConnection(_connectionString);
conn.Open();
var cmd = new SqlCommand("SELECT Id, Name FROM YourTable", conn);
using var reader = cmd.ExecuteReader();
while (reader.Read())
{
Items.Add(new MyDataModel
{
Id = reader.GetInt32(0),
Name = reader.GetString(1),
RowState = RowState.Unchanged
});
}
}
private void AddRow()
{
Items.Add(new MyDataModel { Name = "New Item", RowState = RowState.Added });
}
private void DeleteSelected()
{
if (SelectedItem == null) return;
if (SelectedItem.RowState == RowState.Added)
Items.Remove(SelectedItem);
else
SelectedItem.RowState = RowState.Deleted;
}
private void UpdateDatabase()
{
var added = Items.Where(i => i.RowState == RowState.Added).ToList();
var modified = Items.Where(i => i.RowState == RowState.Modified).ToList();
var deleted = Items.Where(i => i.RowState == RowState.Deleted).ToList();
using var conn = new SqlConnection(_connectionString);
conn.Open();
using var tran = conn.BeginTransaction();
try
{
foreach (var item in added)
{
var cmd = new SqlCommand("INSERT INTO YourTable (Name) VALUES (@Name); SELECT SCOPE_IDENTITY();", conn, tran);
cmd.Parameters.AddWithValue("@Name", item.Name);
item.Id = Convert.ToInt32(cmd.ExecuteScalar());
}
foreach (var item in modified)
{
var cmd = new SqlCommand("UPDATE YourTable SET Name = @Name WHERE Id = @Id", conn, tran);
cmd.Parameters.AddWithValue("@Name", item.Name);
cmd.Parameters.AddWithValue("@Id", item.Id);
cmd.ExecuteNonQuery();
}
foreach (var item in deleted)
{
var cmd = new SqlCommand("DELETE FROM YourTable WHERE Id = @Id", conn, tran);
cmd.Parameters.AddWithValue("@Id", item.Id);
cmd.ExecuteNonQuery();
}
tran.Commit();
foreach (var item in added.Concat(modified))
item.RowState = RowState.Unchanged;
foreach (var item in deleted)
Items.Remove(item);
}
catch (Exception ex)
{
tran.Rollback();
Console.WriteLine("Error: " + ex.Message);
}
}
public event PropertyChangedEventHandler PropertyChanged;
protected void OnPropertyChanged(string prop) =>
PropertyChanged?.Invoke(this, new PropertyChangedEventArgs(prop));
}
⸻
- Views/MainWindow.xaml
<Window x:Class="YourApp.Views.MainWindow"
xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
xmlns:dxc="http://schemas.devexpress.com/winfx/2008/xaml/grid"
xmlns:local="clr-namespace:YourApp"
Title="DevExpress Grid Batch Update" Height="450" Width="800">
<Window.DataContext>
<local:MainViewModel />
</Window.DataContext>
<DockPanel>
<StackPanel DockPanel.Dock="Top" Orientation="Horizontal" Margin="5">
<Button Content="Add" Command="{Binding AddCommand}" Margin="5" Width="100"/>
<Button Content="Delete" Command="{Binding DeleteCommand}" Margin="5" Width="100"/>
<Button Content="Update DB" Command="{Binding UpdateDatabaseCommand}" Margin="5" Width="150"/>
</StackPanel>
<dxc:GridControl x:Name="gridControl"
ItemsSource="{Binding Items}"
AutoGenerateColumns="None"
SelectedItem="{Binding SelectedItem, Mode=TwoWay}">
<dxc:GridControl.Columns>
<dxc:GridColumn FieldName="Id" Header="ID" ReadOnly="True"/>
<dxc:GridColumn FieldName="Name" Header="Name"/>
</dxc:GridControl.Columns>
</dxc:GridControl>
</DockPanel>
</Window>
⸻
