Winform开发之DataGridView的增删改

DataGridView是一个非常强大的控件，用法很多。这里介绍一个简单的增删改例子。

贴效果图

右侧输入学生信息点击新增，将数据增加到数据库，并且加载到datagridview中，点击选择某条数据修改，将选择的数据加载到右侧的编辑框内，修改后点击修改即可，也可直接删除。

贴代码

 public partial class Form1 : Form
    {
        
        private static string strConn = "Data Source=210.26.*.*;Initial Catalog=Test;User ID=sa;Password=****";
        private SqlConnection conn = new SqlConnection(strConn);
        private string sqlId = "";
        private SqlCommand cmd = null;
        private SqlDataAdapter da = null;

        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {                       
            //SqlDataReader studentlist = cmd.ExecuteReader();
            //bindingSource1.DataSource = studentlist;
            //dataGridView1.DataSource = bindingSource1;
            BindData();
        }
        private void BindData()
        {
            if (conn.State == ConnectionState.Closed)
            {
                conn.Open();
            }
            sqlId = "select * from [Student] ";           
            cmd = new SqlCommand(sqlId, con