DataGridView（C#使用SqlDataAdapter.Update更新数据库）

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;

using System.Data.SqlClient;

namespace PrjCodeManage
{
    public partial class FrmPosiType : Form
    {
        public FrmPosiType()
        {
            InitializeComponent();
        }

        SqlConnection cn = new SqlConnection("Data Source=MICROSOF-406AD7//SQLEXPRESS;Initial Catalog=JYDB;Integrated Security=True");
        SqlCommand cm = new SqlCommand();
        DataSet ds = new DataSet();
        SqlDataAdapter da = new SqlDataAdapter();
        SqlCommandBuilder cb = new SqlCommandBuilder();
        private void FrmPosiType_Load(object sender, EventArgs e)
        {

            cm = new SqlCommand("select * from HR_TrainType", cn);
            da = new SqlDataAdapter(cm);
            da.Fill(ds, "HR_TrainType");
             this.dataGridView1.DataSource = ds.Tables["HR_TrainType"];
        }
        private void tsbSave_Click(object sender, EventArgs e)
        {
              cm = cn.CreateCommand();
            cm.CommandText = "select * from HR_TrainType";
            da = new SqlDataAdapter(cm);
            cb = new SqlCommandBuilder(da);
            da.Update(ds.Tables[0]);
            this.dataGridView1.Update();
            //MessageBox.Show("保存成功！");
        }
    }
}

 

 

后记：功能确实实现了，可是要将光标从编辑的单元格中移出后，保存才好用，我自己感觉还是十分难用的，大家伙有没有好的解决办法？