DataGridView连接Sql数据库 功能 查询 添加 删除 修改

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 System.Data.SqlClient;
namespace _03大项目
{
    public partial class Form1 : Form
    {
        //连接字符串
        string str = "Data Source=.;Initial Catalog=MyDeskInfo;Integrated Security=True";
        public Form1()
        {
            InitializeComponent();
        }
        //窗体加载
        private void Form1_Load(object sender, EventArgs e)
        {
            //加载餐桌
            LoadDeskInfoByDelFlag(0);
        }
        /// <summary>
        /// 该方法是加载所有没有被删除的餐桌
        /// </summary>
        /// <param name="p">删除标识 0---未删除,1---删除</param>
        private void LoadDeskInfoByDelFlag(int p)
        {
            List<DeskInfo> list = new List<DeskInfo>();


            //通过连接字符串连接数据库
            using (SqlConnection con = new SqlConnection(str))
            {
                //拼接sql语句
                string sql = "select DeskId,DeskName,DeskNamePinYin,DeskNum from DeskInfo where DeskDelFlag=" + p;
                //准备执行sql语句的对象
                using (SqlCommand cmd =