EF数据持久化 第二章练习(用LinQ、Lambda在Datagridview中管理学生)

目录

​编辑 Model

 添加功能

模糊查找功能

排序功能

---

 

 Model

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace WindowsFormsApplication1
{
  public  class Personmodel
    {
        private string name;

        public string Name
        {
            get { return name; }
            set { name = value; }
        }
        private string age;

        public string Age
        {
            get { return age; }
            set { age = value; }
        }
    }
}

 添加功能

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace WindowsFormsApplication1
{   
    public partial class Form1 : Form
    {
      public static List<Personmodel> list = new List<Personmodel>();
        public Form1()
        {
            InitializeComponent();
        }
       
        private void button1_Click(object sender, EventArgs e)
        {  
            Personmodel model = new Personmodel();
            model.Name = textBox1.Text;
            model.Age = textBox2.Text;
            list.Add(model);
            this.dataGridView1.DataSource = null;
            this.dataGridView1.DataSource = list; 
        }

        private void Form1_Load(object sender, EventArgs e)
        {
           
        }

      
    }
}

模糊查找功能

  private void button2_Click(object sender, EventArgs e)
        {
            List<Personmodel> neww = list.Where(x =>x.Name.Contains(textBox1.Text)).ToList();
            this.dataGridView1.DataSource = null;
            this.dataGridView1.DataSource = neww; 
        }

排序功能

private void button3_Click(object sender, EventArgs e)
        {
            List<Personmodel> newl = list.OrderBy(x => x.Age).ToList();
            this.dataGridView1.DataSource = null;
            this.dataGridView1.DataSource = newl; 


        }