ExecuteNonQuery 修改密码老错

[哎算了]

using System; 
using System.Data; 
using System.Configuration; 
using System.Web; 
using System.Web.Security; 
using System.Web.UI; 
using System.Web.UI.WebControls; 
using System.Web.UI.WebControls.WebParts; 
using System.Web.UI.HtmlControls;
using System.Data.OleDb;
using MyMd5;//引进md5的类

public partial class loginedit:BasePage
{
    protected void Page_Load(object sender, EventArgs e) 
    {
			T_usn.Text+=Session["UserName"];
    } 
	
	
	protected void T_pswClick(object sender, EventArgs e)
    {
        if (Page.IsValid)
        {
			string strconn =ConfigurationManager.AppSettings["SQLConnString"].ToString() + Server.MapPath(ConfigurationManager.AppSettings["dbPath"]) + ";";
            OleDbConnection conn = new OleDbConnection(strconn);
            string Pwd1 = "";
			string Pwd2 = "";
            Pwd1 = MyMd5.MyFM.GetMD5Hash(T_psw1.Text.Trim(),16);
			Pwd2 = MyMd5.MyFM.GetMD5Hash(T_psw2.Text.Trim(),16);
			
            string Sql1;
			string Sql2;
			
            Sql1 = "select count(*) from [admin] where aid='" + Convert.ToInt32(Request.QueryString["xid"]) + "' and password='" + Pwd1 + "'";
            OleDbCommand cmd1 = new OleDbCommand(Sql1, conn);
            conn.Open();
			
				int ret1 = cmd1.ExecuteNonQuery();//判断数据库是否为空
				if (ret1 <= 0)
				{
					Response.Write("<script> alert(\"修改失败！旧密码错误！\")</script>");
				}
				else
				{
				
				Sql2 = "update from [admin] set password='" + Pwd2 + "' where aid='" + Convert.ToInt32(Request.QueryString["xid"]) + "'";
				OleDbCommand cmd2 = new OleDbCommand(Sql2, conn);
				conn.Open();
				int ret2 = cmd2.ExecuteNonQuery();//判断数据库是否为空
            	if (ret2 > 0)
            	{
        		Session.Clear();
        		Session.Abandon();
                Response.Write("<script> alert(\"修改成功！\")</script>");
				Response.Redirect("Login.aspx"); 
				}
				else
				{
				Response.Write("<script> alert(\"修改失败！\")</script>");
				}
                
            }
			
			conn.Close();
		
		}
    }
}

提示下面错误。

异常详细信息: System.Data.OleDb.OleDbException: 标准表达式中数据类型不匹配。

源错误:


行 37: conn.Open();
行 38:
行 39: int ret1 = cmd1.ExecuteNonQuery();//判断数据库是否为空
行 40: if (ret1 <= 0)
行 41: {

[姎楹]

你先int ret1=0；在赋值看看可能是cmd1.ExecuteNonQuery()返回的“”

[哎算了]

引用 1 楼 姎楹 的回复:

你先int ret1=0；在赋值看看可能是cmd1.ExecuteNonQuery()返回的“”

using System; 
using System.Data; 
using System.Configuration; 
using System.Web; 
using System.Web.Security; 
using System.Web.UI; 
using System.Web.UI.WebControls; 
using System.Web.UI.WebControls.WebParts; 
using System.Web.UI.HtmlControls;
using System.Data.OleDb;
using MyMd5;//引进md5的类

public partial class loginedit:BasePage
{
    protected void Page_Load(object sender, EventArgs e) 
    {
			T_usn.Text+=Session["UserName"];
    } 
	
	
	protected void T_pswClick(object sender, EventArgs e)
    {
        if (Page.IsValid)
        {
			string strconn =ConfigurationManager.AppSettings["SQLConnString"].ToString() + Server.MapPath(ConfigurationManager.AppSettings["dbPath"]) + ";";
            OleDbConnection conn = new OleDbConnection(strconn);
            string Pwd1 = "";
			string Pwd2 = "";
            Pwd1 = MyMd5.MyFM.GetMD5Hash(T_psw1.Text.Trim(),16);
			Pwd2 = MyMd5.MyFM.GetMD5Hash(T_psw2.Text.Trim(),16);
			
            string Sql1;
			string Sql2;
			
            Sql1 = "select count(*) from [admin] where aid='" + Convert.ToInt32(Request.QueryString["xid"]) + "' and password='" + Pwd1 + "'";
            OleDbCommand cmd1 = new OleDbCommand(Sql1, conn);
            conn.Open();
				int ret1=0;
				ret1 = cmd1.ExecuteNonQuery();//判断数据库是否为空
				if (ret1 <= 0)
				{
					Response.Write("<script> alert(\"修改失败！旧密码错误！\")</script>");
				}
				else
				{
				
				Sql2 = "update from [admin] set password='" + Pwd2 + "' where aid='" + Convert.ToInt32(Request.QueryString["xid"]) + "'";
				OleDbCommand cmd2 = new OleDbCommand(Sql2, conn);
				conn.Open();
				int ret2=0;
				ret2 = cmd2.ExecuteNonQuery();//判断数据库是否为空
            	if (ret2 > 0)
            	{
        		Session.Clear();
        		Session.Abandon();
                Response.Write("<script> alert(\"修改成功！\")</script>");
				Response.Redirect("Login.aspx"); 
				}
				else
				{
				Response.Write("<script> alert(\"修改失败！\")</script>");
				}
                
            }
			
			conn.Close();
		
		}
    }
}

还是不行，提示错误。

异常详细信息: System.Data.OleDb.OleDbException: 标准表达式中数据类型不匹配。

源错误:


行 37: conn.Open();
行 38: int ret1=0;
行 39: ret1 = cmd1.ExecuteNonQuery();//判断数据库是否为空
行 40: if (ret1 <= 0)
行 41: {

[大葡萄八块一斤]

select count(*)这个语句，应该使用cmd1.ExecuteScalar();表示执行查询并返回查询所返回的结果集中第一行的第一列。

[姎楹]

dei ，楼上讲的dei