1 private Boolean dbUpdate ()
2 {
3 string strSql = "select ProductsSpecID, ProductsSpec, ProductsSpecUnit, ProductsID from tbl_product_detail_master ";
4 System. Data. DataTable dtUpdate = new System. Data. DataTable ();
5 dtUpdate = this. dbconn (strSql );
6 dtUpdate. Rows. Clear ();
7
8 System. Data. DataTable dtShow = new System. Data. DataTable ();
9 // dtShow = (DataTable) this. bindSource. DataSource;
10 dtShow = (System. Data. DataTable) this. dgselect. DataSource;
11
12 int p1 = dtShow. Rows. Count;
13 // try
14 //{
15
16 for (int I = 0; I <dtShow. Rows. Count; I ++)
17 {
18 DataRowState rowState = new DataRowState ();
19 rowState = dtShow. Rows [I]. RowState;
20 if (rowState = DataRowState. Added | rowState = DataRowState. Detached | rowState = DataRowState. Modified)
21 {
22
23 if (this. dgselect ["Del", I]. Value. ToString () = "1 ")
24 {
25 dtShow. Rows [I]. Delete ();
26}
27}
28}
29
30 for (int I = 0; I <dtShow. Rows. Count; I ++)
31 {
32 dtUpdate. ImportRow (dtShow. Rows [I]);
33}
34 int num = dtUpdate. Rows. Count;
35 try
36 {
37 this. conn. Open ();
38
39 trans = this. conn. BeginTransaction ();
40
41 MySqlCommandBuilder CommandBuiler;
42 CommandBuiler = new MySqlCommandBuilder (this. adapter );
43
44 this. adapter. Update (dtUpdate );
45 trans. Commit ();
46 this. conn. Close ();
47
48}
49 catch (Exception ex)
50 {
51 MessageBox. Show (ex. Message. ToString ());
52 trans. Rollback ();
53 return false;
54}
55
56 dtUpdate. AcceptChanges ();
57 return true;
58
59}