1. 
   using
   
   System;
2. 
   using
   
   System.Collections.Generic;
3. 
   using
   
   System.ComponentModel;
4. 
   using
   
   System.Data;
5. 
   using
   
   System.Drawing;
6. 
   using
   
   System.Linq;
7. 
   using
   
   System.Text;
8. 
   using
   
   System.Windows.Forms;
10. 
    using
    
    System.Data.SqlClient;
13. 
    namespace
    
    AllSaveGrid
14. {
15. 
    public
    
    partial
    
    class
    
    Form1 : Form
16. {
18. DataSet ds =
    
    new
    
    DataSet();
20. 
    public
    
    Form1()
21. {
22. InitializeComponent();
23. GridControl_Bind();
24. }
25. 
    public
    
    
    void
    
    GridControl_Bind()
26. {
27. SqlClass sc =
    
    new
    
    SqlClass();
28. 
    //DataSet ds = new DataSet();
    
29. ds = sc.SelTable();
    
    //获取DataGridView的数据源
    
30. dataGridView1.DataSource = ds.Tables[0];
31. }
33. 
    private
    
    
    void
    
    button1_Click(
    
    object
    
    sender, EventArgs e)
34. {
36. SqlConnection con =
    
    new
    
    SqlConnection(
    
    "server='localhost';database='Work';user='sa';password='123'"
    
    );
37. SqlCommand cmd =
    
    new
    
    SqlCommand();
38. cmd = con.CreateCommand();
39. cmd.CommandText =
    
    "select * from Table_gongzi"
    
    ;
40. SqlDataAdapter da =
    
    new
    
    SqlDataAdapter(cmd);
42. SqlCommandBuilder cb =
    
    new
    
    SqlCommandBuilder(da);
    
    //使用SqlCommandBuilder的话，首先要求你的表有主键
    
43. 
    //然后他会根据你提供的查询语句，生成插入，修改，删除语句
    
44. 
    //再根据DataTable对应的数据行状态来调用对应的语句执行数据库操作
    
45. da.Update(ds.Tables[0]);
46. dataGridView1.Update();
47. }
49. 
    private
    
    
    void
    
    button2_Click(
    
    object
    
    sender, EventArgs e)
50. {
51. DataRowView drv = dataGridView1.SelectedRows[0].DataBoundItem
    
    as
    
    DataRowView;
52. drv.Delete();
54. SqlConnection con =
    
    new
    
    SqlConnection(
    
    "server='localhost';database='Work';user='sa';password='123'"
    
    );
55. SqlCommand cmd =
    
    new
    
    SqlCommand(
    
    "select * from Table_gongzi"
    
    , con);
56. 
    //          SqlCommand cmd = new SqlCommand();
    
57. 
    //          cmd = con.CreateCommand();
    
58. 
    //          cmd.CommandText = "select * from Table_gongzi";
    
60. SqlDataAdapter da =
    
    new
    
    SqlDataAdapter(cmd);
61. SqlCommandBuilder cb =
    
    new
    
    SqlCommandBuilder(da);
    
    //必须new SqlCommandBuilder 否则da.Update报错
    
62. da.Update(ds.Tables[0]);
63. dataGridView1.Update();
64. }
65. }
66. }

转载声明：


本文转自

http://blog.csdn.net/shanzhaikaifa/archive/2009/08/13/4443931.aspx