winform —— listview创建表及简单的增删改查

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using WindowsFormsApplication7.App_Code;

namespace WindowsFormsApplication7
{
    public partial class Form4 : Form
    {
        public Form4()
        {
            InitializeComponent();
        }
        //新增
        private void button1_Click(object sender, EventArgs e)
        {
            Insert f = new Insert();//打开Insert新增窗体
            f.Owner = this;
            f.Show();
        }
        //窗体一运行就执行
        private void Form4_Load(object sender, EventArgs e)
        {
            List<UserData> list = new UserDA().Select();//查询数据库对应数据
            Binddata(list);//绑定数据
        }

        private void Binddata(List<UserData> list)
        { 
            //第一步：构建listview"'
            listView1.Columns.Clear();
            listView1.Columns.Add("编号");
            listView1.Columns.Add("用户名");
            listView1.Columns.Add("密码");

            listView1.Items.Clear();

            //读取数据，通过数据构建listview中的行

            foreach (UserData data in list)
            {
                ListViewItem lt = new ListViewItem();
                lt.Text = data.Code.ToString();
                lt.SubItems.Add(data.Uname);
                lt.SubItems.Add(data.UPass);

                listView1.Items.Add(lt);
            }
        }
        //条件查询
        private void button4_Click(object sender, EventArgs e)
        {
            List<UserData> listtiaojian =  new UserDA().Select(textBox1.Text);
            Binddata(listtiaojian);
        }
        //删除数据
        private void button3_Click(object sender, EventArgs e)
        {
            if (listView1.SelectedItems.Count > 0)
            {
               string code = listView1.SelectedItems[0].Text;
               new UserDA().Delete(code);
                //重新绑定数据
               List<UserData> list = new UserDA().Select();
               Binddata(list);
            }
            else
            {
                MessageBox.Show("请选择，再删除");
            }
        }
        //修改数据
        private void button2_Click(object sender, EventArgs e)
        {
            if (listView1.SelectedItems.Count > 0)
            {
                UserData data = new UserData();
                data.Code = int.Parse(listView1.SelectedItems[0].SubItems[0].Text);
                data.Uname = listView1.SelectedItems[0].SubItems[1].Text;
                data.UPass = listView1.SelectedItems[0].SubItems[2].Text;
                Update f = new Update(data);
                f.Show();
            }
            else
            {
                MessageBox.Show("请选择，再修改");
            }

           
        }
    }
}