直接修改Datagridview并保存到数据库

using System;  
using System.Collections.Generic;  
using System.ComponentModel;  
using System.Data;  
using System.Drawing;  
using System.Text;  
using System.Windows.Forms;  
using System.Collections;  
using System.Data.SqlClient;  
  
namespace Quanxian  
{  
    public partial class Form2 : Form  
    {  
        public Form2()  
        {  
            InitializeComponent();  
        }  
        private int job_id;  
        private string job_desc;  
        private int min_lvl;  
        private int max_lvl;  
  
        private void Form2_Load(object sender, EventArgs e)  
        {  
            binddatagridview();  
        }  
        /// <summary>  
        /// 绑定Datagridview的方法  
        /// </summary>  
        private void binddatagridview()  
        {  
            SqlConnection sqlcon = new SqlConnection("server=.;uid=sa;pwd=;database=pubs");  
            SqlDataAdapter sqldap = new SqlDataAdapter("select * from jobs", sqlcon);  
            DataSet ds = new DataSet();  
            sqldap.Fill(ds);  
            this.dataGridView1.DataSource = ds.Tables[0];  
        }  
        /// <summary>  
        /// 编辑单元格后触发  
        /// </summary>  
        /// <param name="sender"></param>  
        /// <param name="e"></param>  
        private void dataGridView1_CellEndEdit(object sender, DataGridViewCellEventArgs e)  
        {  
            if (dataGridView1.Rows.Count > 0)  
            {  
                job_id = int.Parse (this.dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString());  
                job_desc = this.dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString();  
                min_lvl = int.Parse(this.dataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString());  
                max_lvl = int.Parse(this.dataGridView1.Rows[e.RowIndex].Cells[3].Value.ToString());  
            }  
        }  
        /// <summary>  
        /// 修改  
        /// </summary>  
        private void button1_Click(object sender, EventArgs e)  
        {  
            SqlConnection sqlcon = new SqlConnection("server=.;uid=sa;pwd=;database=pubs");  
            string str = "update jobs set job_desc='" + job_desc + "',min_lvl=" + min_lvl + ",max_lvl=" + max_lvl + " where job_id=" + job_id + "";  
            SqlCommand sqlcom = new SqlCommand(str,sqlcon);  
            try  
            {  
                sqlcon.Open();  
                if (sqlcom.ExecuteNonQuery() > 0)  
                    MessageBox.Show("保存成功");  
                else  
                    MessageBox.Show("保存失败!");  
            }  
            catch  
            {     
                //异常  
            }  
            finally  
            { sqlcon.Close();}  
        }  
        /// <summary>  
        /// 刷新  
        /// </summary>  
        private void button2_Click(object sender, EventArgs e)  
        {  
            binddatagridview();  
        }  
    }  
}