DataGridView（VS中表格）删除和刷新

超、凢脫俗 2023-06-01 05:48 11阅读 0赞

# 功能描述：右击表格中对应的行，进行删除或者刷新的操作。 #

1.  先往DataGridView上拖一个ContextMenuStrip控件  
    ![在这里插入图片描述][2019113016360826.png]
2.  在下面分别输入删除与刷新  
    ![在这里插入图片描述][20191130163620460.png]
3.  双击删除，输入代码：

private void 删除ToolStripMenuItem_Click_1(object sender, EventArgs e)
            { 
                try
                { 
                    DialogResult dr = MessageBox.Show("确定删除吗？", "提示", MessageBoxButtons.OKCancel);
                    if (dr == DialogResult.OK)
                    { 
                        //获取选中行的数据
                        Facade.FoodMenuCateFaçade façade = new Facade.FoodMenuCateFaçade();
                        Entity.T_FoodMenuCate t_Food = new Entity.T_FoodMenuCate();
                        t_Food.CateName = dataFood.CurrentRow.Cells[1].Value.ToString();
                        int list1 = façade.DeleteFoodMenu(t_Food);
    
                        frmTips f = frmTips.GetInstance("删除完成");
                        f.Show();
                    }
    
                }
                catch (Exception ex)
                { 
                    MessageBox.Show(ex.Message);
                }
            }

1.  双击刷新，输入代码：

private void 刷新ToolStripMenuItem_Click(object sender, EventArgs e)
            { //通过走七层查询出数据库中新的内容：
                Facade.FoodMenuCateFaçade façade = new Facade.FoodMenuCateFaçade();
                Entity.T_FoodMenuCate t_Food = new Entity.T_FoodMenuCate();
                List<Entity.T_FoodMenuCate> list = façade.SelectFoodMenu(t_Food);
                //把值赋给表格
                dataFood.DataSource = list;
            }

[2019113016360826.png]: /images/20230601/80b5dfeb7bef4b2b98780bd6d118bd8f.png
[20191130163620460.png]: /images/20230601/f33b4f00bbb745ddb8237fa78226986a.png