函数如下:public static bool UpdataPassword(string newpassword,string userid) //更新密码
{
OleDbConnection Dbconn;
Dbconn=neto.db.DbConn.getdbConn();
try
{
Dbconn.Open();
OleDbCommand Dbcom = new OleDbCommand();
Dbcom.Connection=Dbconn;
Dbcom.CommandText="update OPERATOR set PASSWORD=? where USERID=?";
Dbcom.Parameters.Add(new System.Data.OleDb.OleDbParameter("PASSWORD", System.Data.OleDb.OleDbType.VarChar, 80, "PASSWORD"));
Dbcom.Parameters.Add(new System.Data.OleDb.OleDbParameter("USERID", System.Data.OleDb.OleDbType.VarChar, 80, "USERID"));
Dbcom.Parameters["PASSWORD"].Value=newpassword;
Dbcom.Parameters["USERID"].Value=userid;
Dbcom.ExecuteNonQuery();
return true; //
}
catch (Exception e)
{
string tr=e.Message;
return false;
}
finally
{
Dbconn.Close();
}
}
}
为什么我执行到Dbcom.ExecuteNonQuery();的时候就停在那什么反应也没有了呢,单独执行update语句是行的,,奇怪啊
{
OleDbConnection Dbconn;
Dbconn=neto.db.DbConn.getdbConn();
try
{
Dbconn.Open();
OleDbCommand Dbcom = new OleDbCommand();
Dbcom.Connection=Dbconn;
Dbcom.CommandText="update OPERATOR set PASSWORD=? where USERID=?";
Dbcom.Parameters.Add(new System.Data.OleDb.OleDbParameter("PASSWORD", System.Data.OleDb.OleDbType.VarChar, 80, "PASSWORD"));
Dbcom.Parameters.Add(new System.Data.OleDb.OleDbParameter("USERID", System.Data.OleDb.OleDbType.VarChar, 80, "USERID"));
Dbcom.Parameters["PASSWORD"].Value=newpassword;
Dbcom.Parameters["USERID"].Value=userid;
Dbcom.ExecuteNonQuery();
return true; //
}
catch (Exception e)
{
string tr=e.Message;
return false;
}
finally
{
Dbconn.Close();
}
}
}
为什么我执行到Dbcom.ExecuteNonQuery();的时候就停在那什么反应也没有了呢,单独执行update语句是行的,,奇怪啊
解决方案 »
- asp.net开发网站速度问题
- asp.net上传图片到独立服务器,提示【对路径“C:\...\873_2.jpg"的访问被拒绝】的错误
- |M| 如何让asp:RequiredFieldValidator 验证成功或失败的时候用alert('')来提示
- 100分求高手指点!!!关于SQL聚合函数的查询语句 !!!
- asp.net 应用中调用cmd.exe的问题
- 怎么分配系统的权限. 级别和角色 谢谢(急求)
- 如何用C#把网页转换成PDF文件,我下了程序,调不过去,朋友们能帮我一次吗?
- 我的.net不能调试了,不知为何?
- 我用Google搜索过“XML电子图书”
- 谁有DATAGRID控件自定义分页的完整C#代码??
- 一个ASPX文件中包含ASP代码,应该怎么办?
- 各位啊!问点事?VS2005的正式版出来了吗?哪有下载的啊?
改为这样试下:
update OPERATOR set PASSWORD='?' where USERID='?'
Dbcom.Parameters.Add(new System.Data.OleDb.OleDbParameter("USERID", System.Data.OleDb.OleDbType.VarChar, 80, "USERID"));
Dbcom.Parameters["PASSWORD"].Value=newpassword;
Dbcom.Parameters["USERID"].Value=userid;
里面有错误,检查一下吧
string mySelectQuery, OleDbParameter[] myParamArray) {
OleDbCommand myCommand = new OleDbCommand(mySelectQuery, myConnection);
myCommand.CommandText = "SELECT CustomerID, CompanyName FROM Customers WHERE Country = ? AND City = ?";
myCommand.Parameters.Add(myParamArray);
for (int j=0; j<myParamArray.Length; j++)
{
myCommand.Parameters.Add(myParamArray[j]) ;
}
string myMessage = "";
for (int i = 0; i < myCommand.Parameters.Count; i++)
{
myMessage += myCommand.Parameters[i].ToString() + "\n";
}
MessageBox.Show(myMessage);
}