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

来源：互联网发布：合肥大数据产业园区编辑：程序博客网时间：2024/05/16 17:22

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);