**前言:**CURD无论是B/S、还是C/S开发,这个是新手编程遇到的第一个门槛,也是后续编程过程中,一直使用的技能。我当初第一份实习的题目只有一个,那就是基于现有框架,写一个增删改查的demo。
废话不多说,我们来写第一个实例(新手用户,完全不懂WPF,不知道MVVM等知识);
1、先创建一个wpf项目,把默认的Gird布局修改为StackPanel布局(datagrid布局写的代码太多了,有点懒,就用StackPanel布局,然后一个控件一个控件往上扔就好了);
2、添加一个Datagrid 添加支持增删改功能的布局。
`<Window x:Class="DataGridDemo.MainWindow"
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:DataGridDemo"
mc:Ignorable="d"
Title="MainWindow" Height="450" Width="800">
<StackPanel>
<!--Datagrid列表模块-->
<DataGrid x:Name="DGstudent" CanUserAddRows="False" CanUserReorderColumns="False" CanUserResizeColumns="False" CanUserResizeRows="False"
CanUserDeleteRows="False" CanUserSortColumns="False" AutoGenerateColumns="True" SelectedCellsChanged="DGstudent_SelectedCellsChanged">
</DataGrid>
<!--修改模块-->
<WrapPanel x:Name="WpModify">
<Label>ID:</Label>
<TextBox Width="100" IsReadOnly="True" x:Name='TbModifyID'></TextBox>
<Label>姓名:</Label>
<TextBox Width="300" x:Name="TbModifyName"></TextBox>
<Label>性别:</Label>
<ComboBox Width="100" x:Name="TbModifySex">
<ComboBoxItem Content="未知" ></ComboBoxItem>
<ComboBoxItem Content="男" ></ComboBoxItem>
<ComboBoxItem Content="女" ></ComboBoxItem>
</ComboBox>
<Button Content="修改" x:Name="BtnModify" Click="BtnModify_Click"></Button>
<Button Content="删除" x:Name="BtnRemove" Click="BtnRemove_Click"></Button>
</WrapPanel>
<!--新增模块-->
<WrapPanel x:Name="WpAdd">
<Label>姓名:</Label>
<TextBox Width="300" x:Name="TbAddName"></TextBox>
<Label>性别:</Label>
<ComboBox Width="100" x:Name="TbAddSex">
<ComboBoxItem Content="未知" ></ComboBoxItem>
<ComboBoxItem Content="男" ></ComboBoxItem>
<ComboBoxItem Content="女" ></ComboBoxItem>
</ComboBox>
<Button Content="新增" Click="Button_Click"></Button>
</WrapPanel>
</StackPanel>
</Window>
3、给Datagrid绑定上数据源,给按钮添加各种点击事件。完成后代码如下
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Data;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Imaging;
using System.Windows.Navigation;
using System.Windows.Shapes;
namespace DataGridDemo
{
/// <summary>
/// MainWindow.xaml 的交互逻辑
/// </summary>
public partial class MainWindow : Window
{
/// <summary>
/// 数据源---学生集合
/// </summary>
public List<Student> Students { get; set; } = new List<Student>();
public MainWindow()
{
InitializeComponent();
//初始化数据
for(int i = 1; i <= 10; i++) {
Students.Add(new Student()
{
ID = i,
Name = Guid.NewGuid().ToString(),
Sex = (EnumSex)(i%3)
});
}
//设置Datagrid的数据来源为Students
DGstudent.ItemsSource = Students;
}
/// <summary>
/// Datagird的列选择事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void DGstudent_SelectedCellsChanged(object sender, SelectedCellsChangedEventArgs e)
{
var student = (sender as DataGrid).SelectedItem as Student;
if (student!= null){
TbModifyID.Text = student.ID.ToString();
TbModifyName.Text = student.Name;
TbModifySex.SelectedIndex = (int)student.Sex;
RefreshDataGrid();
}
}
/// <summary>
/// 修改按钮的点击事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void BtnModify_Click(object sender, RoutedEventArgs e)
{
var student = Students.FirstOrDefault(x => x.ID.ToString() == TbModifyID.Text);
if (student != null)
{
student.Name = TbModifyName.Text.Trim();
student.Sex = (EnumSex)TbModifySex.SelectedIndex;
RefreshDataGrid();
DGstudent.SelectedIndex = -1;
}
}
/// <summary>
/// 新增按钮点击事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Button_Click(object sender, RoutedEventArgs e)
{
Students.Add(new Student()
{
ID = Students.Max(x=>x.ID) + 1,
Name = TbAddName.Text.Trim(),
Sex = (EnumSex)TbAddSex.SelectedIndex
});
RefreshDataGrid();
}
/// <summary>
/// 刷新Datagrid的数据源
/// </summary>
public void RefreshDataGrid() {
DGstudent.ItemsSource = null;
DGstudent.ItemsSource = Students;
}
/// <summary>
/// 删除按钮的点击事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void BtnRemove_Click(object sender, RoutedEventArgs e)
{
var student = Students.FirstOrDefault(x => x.ID.ToString() == TbModifyID.Text);
Students.Remove(student);
RefreshDataGrid();
}
}
public class Student {
public int ID { get; set; }
public string Name { get; set; }
public EnumSex Sex { get; set; }
}
public enum EnumSex {
Unknow = 0,
Female = 1,
Male = 2
}
}
结语: 这是一个十分简单的例子,当然代码看起来也是十分的low(虽然有故意的嫌疑)。以上就是全部代码,普通的增删改都已经实现了,代码就那么多。有不明白的可以直接复制代码贴进去就可以了。友情提示:项目名称记得命名为DataGridDemo。这样的话真的是一行代码都可以不该。
`