1 private void bt_Save_Click(object sender, System.EventArgs e)  
 2       {  
 3          //创建更新字符串，在.NET开发中应该尽量采用DataSet方式更新 
 4          string sql1="update [distribute] set "; 
 5          sql1+="distributedate='"+TextBox4.Text.Trim()+"',"; 
 6          sql1+="ip='"+TextBox5.Text.Trim()+"',"; 
 7          sql1+="dispersonname='"+TextBox4.Text.Trim()+"' ";  
 8          sql1+="where 你的条件"; 
 9 
10          string sql2="update [pc] set "; 
11          sql2+="pctype='"+TextBox8.Text.Trim()+"',"; 
12          sql2+="brand='"+TextBox9.Text.Trim()+"',"; 
13          sql2+="cpu='"+TextBox10.Text.Trim()+"',"; 
14          sql2+="memory='"+TextBox11.Text.Trim()+"',"; 
15          sql2+="harddisk='"+TextBox12.Text.Trim()+"',"; 
16          sql2+="mainboard='"+TextBox13.Text.Trim()+"',"; 
17          sql2+="optdisk='"+TextBox14.Text.Trim()+"',"; 
18          sql2+="display='"+TextBox15.Text.Trim()+"',"; 
19          //price 如果是数字型则不能用引号括起来 
20          sql2+="price='"+TextBox16.Text.Trim()+"',"; 
21          sql2+="outdevice='"+TextBox17.Text.Trim()+"',"; 
22          sql2+="pc_remark='"+TextBox18.Text.Trim()+"' ";  
23          sql2+="where 你的条件"; 
24           
25 
26          //创建数据对象 
27          SqlConnection conn=new SqlConnection("你的连接字符串，最好写在配置文件中"); 
28          SqlCommand cmd1=new SqlCommand(sql1,conn);  
29          SqlCommand cmd2=new SqlCommand(sql2,conn);  
30            
31          //定义一个事务来保持cmd1/cmd2同步更新 
32          conn.Open(); 
33          SqlTransaction trans=conn.BeginTransaction(); 
34          cmd1.Transaction=trans; 
35          cmd2.Transaction=trans; 
36 
37          try  
38          {  
39             cmd1.ExecuteNonQuery();  
40             cmd2.ExecuteNonQuery();  
41             //事务提交 
42             trans.Commit(); 
43                
44             Response.Redirect("XQKK.aspx");  
45            
46          }  
47          catch(Exception E)  
48          {  
49             //事务回滚 
50             trans.Rollback(); 
51             ErrorMsg.Text=E.Message;  
52          }  
53          finally  
54          {  
55             conn.Close();  
56          }  
57       }  
58 
59