更新数据库中的密码时，为用户提供新的密码_未分类的问答_编程通用

private void UpdatePassword(string UserName, string Password)

    {

        string connectString = @"serve=........";

        SqlConnection conn = new SqlConnection(connectString);

        

        try

        {

            conn.Open();

            SqlCommand cmd = new SqlCommand("sp_UpdatePassword", conn);

            cmd.CommandType = System.Data.CommandType.StoredProcedure;

        }

        catch (SqlException ex)

        {

            Console.WriteLine("Error: " + ex);

        }

        finally

        {

            conn.Close();

        }

    }

/ / / / / /我storeProcedure
{C}
/ / / / / / / /
很多的感谢！

回答

评论会员：游客时间：2012/02/06

RaisKazi:您还没有任何参数传递到你的CMD。有更多的信息，看看下面的链接。imgsrc=更新-{A}在您的代码中的一个问题，你是不是调用的ExecuteNonQuery。{A2}
王子安东尼G

评论会员：游客时间：2012/02/06

替换你的代码:codeprelang="c#"spanclass="code-keyword"private/spanspanclass="code-keyword"void/spanUpdatePassword(spanclass="code-keyword"string/spanEmail,spanclass="code-keyword"string/spanPassword){spanclass="code-keyword"string/spanconnectString=spanclass="code-string"@"/spanspanclass="code-string"serve=........"/span;SqlConnectionconn=spanclass="code-keyword"new/spanSqlConnection(connectString);spanclass="code-keyword"try/span{conn.Open();SqlCommandcmd=spanclass="code-keyword"new/spanSqlCommand(spanclass="code-string""/spanspanclass="code-string"sp_UpdatePassword"/span,conn);cmd.CommandType=System.Data.CommandType.StoredProcedure;cmd.Parameters.Add(spanclass="code-keyword"new/spanSqlParameter(spanclass="code-string""/spanspanclass="code-string"@Email"/span,SqlDbType.VarChar));cmd.Parameters[spanclass="code-string""/spanspanclass="code-string"@Email"/span].Value=Email;cmd.Parameters.Add(spanclass="code-keyword"new/spanSqlParameter(spanclass="code-string""/spanspanclass="code-string"@Password"/span,SqlDbType.VarChar));cmd.Parameters[spanclass="code-string""/spanspanclass="code-string"@Password"/span].Value=Password;cmd.ExecuteScalar();}spanclass="code-keyword"catch/span(SqlExceptionex){Console.WriteLine(spanclass="code-string""/spanspanclass="code-string"Error:"/span+ex);}spanclass="code-keyword"finally/span{conn.Close();}}/pre/code的