DataGridView/C#使用SqlDataAdapte…

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("保存成功！");
        }
    }
}

 

后记：功能确实实现了，可是要将光标从编辑的单元格中移出后，保存才好用

本文来自CSDN博客，转载请标明出处：http://blog.csdn.net/kuangniaokuang/archive/2009/12/04/4935457.aspx