Using presqldata. dataprocess;

 

2. UsingSystem;
4. UsingSystem. Collections. Generic;
6. UsingSystem. componentmodel;
8. UsingSystem. Data;
10. UsingSystem. drawing;
12. UsingSystem. LINQ;
14. UsingSystem. text;
16. UsingSystem. Windows. forms;
20. UsingSystem. Data. sqlclient;
26. NamespaceAllsavegrid
28. {
30. PublicPartialClassForm1: Form
32. {
36. Dataset DS =NewDataset ();
40. PublicForm1 ()
42. {
44. Initializecomponent ();
46. Gridcontrol_bind ();
48. }
50. Public VoidGridcontrol_bind ()
52. {
54. Sqlclass SC =NewSqlclass ();
56. // Dataset DS = new dataset ();
58. DS = SC. seltable ();// Obtain the data source of the datagridview.
60. Datagridview1.datasource = Ds. Tables [0];
62. }
66. Private VoidButton#click (ObjectSender, eventargs E)
68. {
72. Sqlconnection con =NewSqlconnection ("Server = 'localhost'; database = 'work'; user = 'sa '; Password = '000000 '");
74. Sqlcommand cmd =NewSqlcommand ();
76. Cmd = con. createcommand ();
78. Cmd. commandtext ="Select * From table_gongzi";
80. Sqldataadapter da =NewSqldataadapter (CMD );
84. Sqlcommandbuilder cb =NewSqlcommandbuilder (DA );// If sqlcommandbuilder is used, your table must first have a primary key.
86. // Then, the insert, modify, and delete statements are generated based on the query statements you provide.
88. // Then, the corresponding statement is called Based on the Data row status of the datatable to perform database operations.
90. Da. Update (Ds. Tables [0]);
92. Datagridview1.update ();
94. }
98. Private VoidButton2_click (ObjectSender, eventargs E)
100. {
102. Datarowview DRV = maid [0]. databounditemAsDatarowview;
104. DRV. Delete ();
108. Sqlconnection con =NewSqlconnection ("Server = 'localhost'; database = 'work'; user = 'sa '; Password = '000000 '");
110. Sqlcommand cmd =NewSqlcommand ("Select * From table_gongzi", Con );
112. // Sqlcommand cmd = new sqlcommand ();
114. // Cmd = con. createcommand ();
116. // Cmd. commandtext = "select * From table_gongzi ";
120. Sqldataadapter da =NewSqldataadapter (CMD );
122. Sqlcommandbuilder cb =NewSqlcommandbuilder (DA );// New sqlcommandbuilder is required; otherwise, an error is returned for DA. Update.
124. Da. Update (Ds. Tables [0]);
126. Datagridview1.update ();
128. }
130. }
132. }

 

Reprinted statement:This article from http://blog.csdn.net/shanzhaikaifa/archive/2009/08/13/4443931.aspx