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

1. using System;  
2. using System.Collections.Generic;  
3. using System.ComponentModel;  
4. using System.Data;  
5. using System.Drawing;  
6. using System.Text;  
7. using System.Windows.Forms;  
8. using System.Collections;  
9. using System.Data.SqlClient;  
10.   
11. namespace Quanxian  
12. {  
13.     public partial class Form2 : Form  
14.     {  
15.         public Form2()  
16.         {  
17.             InitializeComponent();  
18.         }  
19.         private int job_id;  
20.         private string job_desc;  
21.         private int min_lvl;  
22.         private int max_lvl;  
23.   
24.         private void Form2_Load(object sender, EventArgs e)  
25.         {  
26.             binddatagridview();  
27.         }  
28.         /// <summary>  
29.         /// 绑定Datagridview的方法  
30.         /// </summary>  
31.         private void binddatagridview()  
32.         {  
33.             SqlConnection sqlcon = new SqlConnection("server=.;uid=sa;pwd=;database=pubs");  
34.             SqlDataAdapter sqldap = new SqlDataAdapter("select * from jobs", sqlcon);  
35.             DataSet ds = new DataSet();  
36.             sqldap.Fill(ds);  
37.             this.dataGridView1.DataSource = ds.Tables[0];  
38.         }  
39.         /// <summary>  
40.         /// 编辑单元格后触发  
41.         /// </summary>  
42.         /// <param name="sender"></param>  
43.         /// <param name="e"></param>  
44.         private void dataGridView1_CellEndEdit(object sender, DataGridViewCellEventArgs e)  
45.         {  
46.             if (dataGridView1.Rows.Count > 0)  
47.             {  
48.                 job_id = int.Parse (this.dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString());  
49.                 job_desc = this.dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString();  
50.                 min_lvl = int.Parse(this.dataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString());  
51.                 max_lvl = int.Parse(this.dataGridView1.Rows[e.RowIndex].Cells[3].Value.ToString());  
52.             }  
53.         }  
54.         /// <summary>  
55.         /// 修改  
56.         /// </summary>  
57.         private void button1_Click(object sender, EventArgs e)  
58.         {  
59.             SqlConnection sqlcon = new SqlConnection("server=.;uid=sa;pwd=;database=pubs");  
60.             string str = "update jobs set job_desc='" + job_desc + "',min_lvl=" + min_lvl + ",max_lvl=" + max_lvl + " where job_id=" + job_id + "";  
61.             SqlCommand sqlcom = new SqlCommand(str,sqlcon);  
62.             try  
63.             {  
64.                 sqlcon.Open();  
65.                 if (sqlcom.ExecuteNonQuery() > 0)  
66.                     MessageBox.Show("保存成功");  
67.                 else  
68.                     MessageBox.Show("保存失败!");  
69.             }  
70.             catch  
71.             {     
72.                 //异常  
73.             }  
74.             finally  
75.             { sqlcon.Close();}  
76.         }  
77.         /// <summary>  
78.         /// 刷新  
79.         /// </summary>  
80.         private void button2_Click(object sender, EventArgs e)  
81.         {  
82.             binddatagridview();  
83.         }  
84.   
85.     }  
86. }