用access数据库实现更新问题

Question

  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数据库)

Answer 1

access要用?代替@