string strSql = string.Empty;
int result = -1;
OleDbParameter[] oleDbParameters = null;strSql = "insert into t_users(userId,[enabled],pwd,re,regTime,modTime,operator) "
+ "values(@userId,@enabled,@pwd,@re,@regTime,@modTime,@operator)";oleDbParameters = new OleDbParameter[]{
new OleDbParameter("@userId",txtUserId.Text.Trim()),
new OleDbParameter("@enabled",ckbEnabled.Checked),
new OleDbParameter("@pwd",txtPwd.Text.Trim()),
new OleDbParameter("@re",txtRe.Text.Trim()),
new OleDbParameter("@regTime",DateTime.Now),
new OleDbParameter("@modTime",DateTime.Now),
new OleDbParameter("@operator",Identity.userId)
};result = Execute(strSql, oleDbParameters, true);如上代码,执行Execute方法之后就抛出异常提示“至少一个参数没有被指定值”,但是我已经仔细核对过字段,没有输入错误,数目也对得上,可就是提示这个异常,请高手指点·~~~
enabled--真/假
pwd--文本
re--备注
regTime--文本
modTime--文本
operator---文本数据库里字段的数据类型是这样,参数都有值传进去呀
OleDbCommand myCommand = new OleDbCommand(strdel,CCon);
myCommand.ExecuteNonQuery()时,最后一句代码也出现与楼主相同的错误,请高手指教!
语句有问题:
将这句改成这样:
string strdel="delete * from 表名 where Name='”+txtName.Tostring()+"'";