? string Connection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + HttpContext.Current.Server.MapPath("Data/" + ConfigurationManager.ConnectionStrings["OleDbName"].ConnectionString);??????? string sql1 = "update [AdminInfo] set AdminName=@AdminName where AdminID=@AdminID";??????? string sql2 = "update [AdminInfo] set AdminName='bbbb',AdminPassWord='ss' where AdminID='10010'";??????? using (OleDbConnection con = new OleDbConnection(Connection))??????? {??????????? con.Open();??????????? OleDbTransaction trans = con.BeginTransaction();??????????? OleDbCommand com = new OleDbCommand(sql0, con); ??????????? com.Transaction = trans;
??????????? com.Parameters.AddWithValue("@AdminName", "hu");??????????? com.Parameters.AddWithValue("@AdminID", "10010"); ;??????????? ??????????? try??????????? {??????????????? com.ExecuteNonQuery();
??????????????? trans.Commit();
??????????? }??????????? catch (Exception ex)??????????? {??????????????? trans.Rollback();??????????????? throw new Exception(ex.ToString());
??????????? }
??????? }
為什么 用sql1更新不成功,也沒有什么異常出現,用sql2來做就可以,在做添加操作時都是可以成功的.請高手指點,(我用的是access數據庫)
添加回答
舉報
0/150
提交
取消