五、DataTable、DataColumn、DataRow网格数据练习

 完整代码设计：

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 Day21_DataGripView网格控件
{
    
    public partial class Form2 : Form
    {
        DataTable dataTable = null;
        public Form2()
        {
            InitializeComponent();
            BindGridView();
        }

        private void BindGridView()
        {
        // DataTable数据表对象，实例化,但数据表中没有存储任何数据。
            dataTable = new DataTable();
        操作数据表
        1。添加列
        //    // DataColumn创建列对象
        //    DataColumn column = new DataColumn(); 
        //    column.ColumnName = "姓名";
        //    column.DataType = typeof(string);
        //    //设置这个网格的默认内容设置
        //    column.DefaultValue = "未知";
        //    // Add把某列添加到dataTable数据表中。dataTable. Columns.Add (column);
        //    // Add把某列添加到dataTable数据表中。dataTable. Columns.Add (column);
            dataTable.Columns.AddRange(new DataColumn[] {
                new DataColumn("姓名",typeof(string)),
                new DataColumn("年龄",typeof(int)),
                new DataColumn("性别",typeof(string))
            }) ;
            // 2。添加行
            dataTable.Rows.Add(new object[] { "张三",18,"男" }); 
            dataTable.Rows.Add(new object[] { "李四", 19, "女" });

            DataRow dr1 = dataTable.NewRow();
            dr1["姓名"] = "赵六";
            dr1["年龄"] = 18;
            dr1["性别"] = "男";
            dataTable.Rows.Add(dr1);

            DataRow dr2 = dataTable.NewRow();
            dr2[0] = "陈皮";
            dr2[1] = 19;
            dr2[2] = "女";
            dataTable.Rows.Add(dr2);


            dataGridView1.DataSource = dataTable;
            //给第一列绑定右击操作栏
            int count = dataGridView1.Columns.Count;
            for(int i =0;i<count;i++) {
 //dataGridView1.Rows[1].ContextMenuStrip = contextMenuStrip1;//=========不生效
                dataGridView1.Columns[i].ContextMenuStrip = contextMenuStrip1; 
            }       
        }

        private void 删除ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            //选中的一行的第一个单元格的值
            string name = dataGridView1.SelectedRows[0].Cells[0].Value.ToString();
            DataRow dataRow = dataTable.Select($"姓名='{name}'")[0]; 
            dataTable.Rows.Remove(dataRow);
        }

        private void 添加ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            panel1.Visible = true;
            button1.Text = "确认添加";
        }

        private void button1_Click(object sender, EventArgs e)
        {
            string name = textBox1.Text;
            string age = textBox2.Text;
            string sex = textBox3.Text;
            if (string.IsNullOrEmpty(name))
            {
                MessageBox.Show("姓名不能为空");
                return;
            }
            if (string.IsNullOrEmpty(age))
            {
                MessageBox.Show("年龄不能为空");
                return;
            }
            if (string.IsNullOrEmpty(sex))
            {
                MessageBox.Show("性别不能为空");
                return;
            }
            if (button1.Text == "确认添加")
            {
                DataRow dr = dataTable.NewRow();
                dr[0] = name;
                dr[1] = age;
                dr[2] = sex;
                dataTable.Rows.Add(dr);
                DataColumn dc  =  new DataColumn();
                dc.ColumnName = name;
            }
            else if (button1.Text == "确认修改")
            {
                string t1 = textBox1.Text;
                int t2 = Convert.ToInt32(textBox2.Text);
                string t3 = textBox3.Text;
                object OldName = dataGridView1.SelectedRows[0].Cells[0].Value;
                DataRow dataRow = dataTable.Select($"姓名='{OldName}'")[0];
                dataRow[0] = t1;
                dataRow[1] = t2;
                dataRow[2] = t3;
            }
        }

        private void 修改ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            
            panel1.Visible =true;
            button1.Text = "确认修改";
            object value1 = dataGridView1.SelectedRows[0].Cells[0].Value;
            textBox1.Text = (string)value1;
            object value2 = dataGridView1.SelectedRows[0].Cells[1].Value.ToString();
            textBox2.Text = (string)value2;
            object value3 = dataGridView1.SelectedRows[0].Cells[2].Value;
            textBox3.Text = (string)value3;
        }  
    }
}