在C#中使用控件DataGridView直接增删改数据库表的内容

[逸笙]

能不能不用按钮，在_CellBeginEdit和_CellEndEdit直接实现增删改？求代码，详细最好啊，

[Hauk]

        private SqlDataAdapter sda;
        private void Form3_Load(object sender, EventArgs e)
        {
            string connString = "server=.;database=test;uid=sa;pwd=Cdyouxi.kgen-1";
            string selectTxt = "select * from a";
            this.dataGridView1.DataSource = GetData(connString, selectTxt);
        }

        private DataTable GetData(string connString, string selectTxt)
        {
            SqlConnection conn = new SqlConnection(connString);
            SqlCommand cmd = conn.CreateCommand();
            cmd.CommandType = CommandType.Text;
            cmd.CommandText = selectTxt;
            sda = new SqlDataAdapter(cmd);
            DataTable dt = new DataTable();
            sda.Fill(dt);
            SqlCommandBuilder scb = new SqlCommandBuilder(sda);
            return dt;
        }

        private void dataGridView1_CellEndEdit(object sender, DataGridViewCellEventArgs e)
        {
            this.sda.Update((DataTable)this.dataGridView1.DataSource);
        }

[蝶恋花雨]

this.dataGridView1.DataSource = GetData(connString, selectTxt); this.dataGridView1.databind();//少了重新绑定。、

[逸笙]

引用 1 楼 haukwong 的回复:

C# code1234567891011121314151617181920212223242526 private SqlDataAdapter sda; private void Form3_Load(object sender, EventArgs e) { string connString = "s……

最后一行没法保存，而且修改好了直接关闭窗体再打开看没效果啊

[逸笙]

引用 4 楼 kongwei521 的回复:

this.dataGridView1.DataSource = GetData(connString, selectTxt);
this.dataGridView1.databind();//少了重新绑定。、