//组装SQL语句 string sql = string.Format("UPDATE Employee SET EmpName='{0}',EmpAge={1},EmpSex='{2}' WHERE EmpID={3} ",this.txtEmpName.Text, this.txtEmpAge.Text,this.ddlSex.SelectedItem.Text,this.GridView1.DataKeys[this.GridView1.SelectedIndex].Value); //创建使用Windows登陆的 SqlConnection对象 SqlConnection con = new SqlConnection("server=.;uid=sa;pwd=accp;database=demodb"); //创建SqlCommand对象 SqlCommand com = con.CreateCommand(); com.CommandText = sql; //打开连接 con.Open(); int result = 0; //实例化事务对象 SqlTransaction tran = con.BeginTransaction(); //将事务对象与命令对象相关联 com.Transaction = tran; try { //执行UPDATE SQL语句 result = com.ExecuteNonQuery(); //提交事务 tran.Commit(); } catch (SqlException ex) { //出现异常 提醒用户 this.AlertMsg(string.Format("SQL语句发生了异常,异常如下所示:/n{0}",ex.Message)); //回滚事务 tran.Rollback(); } finally { //执行完SQL语句 立即关闭连接 con.Close(); }