.net中access数据库开发要注意的2个小地方

1.Access数据库或者其它数据库不要用password这种关键字做字段名

2.Parms数组是要按sql语句里面出现的顺序排列的

                string sSql = "update cm_courtStatus set CourtUseStatus=@courtUseStatus,CourtDegree=@courtDegree," +
                    "CourtCardId=@courtCardId,GuestPay=@guestPay,CourtInTime=@courtInTime,CourtUseTime=@courtUseTime where CourtID=@courtId";

                OleDbParameter[] Parms=new OleDbParameter[7];

                Parms[0] = new OleDbParameter("@courtUseStatus", OleDbType.VarChar);
                Parms[0].Value = courtStatus.CourtUseStatus;
                Parms[1] = new OleDbParameter("@courtDegree", OleDbType.VarChar);
                Parms[1].Value = courtStatus.CourtDegree;
                Parms[2] = new OleDbParameter("@courtCardId", OleDbType.VarChar);
                Parms[2].Value = courtStatus.CourtCardId;
                Parms[3] = new OleDbParameter("@guestPay", OleDbType.VarChar);
                Parms[3].Value = courtStatus.GuestPay;
                Parms[4] = new OleDbParameter("@courtInTime", OleDbType.Date);
                Parms[4].Value = courtStatus.CourtInTime;
                Parms[5] = new OleDbParameter("@courtUseTime", OleDbType.Integer);
                Parms[5].Value = courtStatus.CourtUseTime;
                Parms[6] = new OleDbParameter("@courtid", OleDbType.VarChar);
                Parms[6].Value = courtStatus.CourtID;

                   OleDbHelper.ExecuteNonQuery(CommandType.Text, sSql, Parms);