代码如下:先谢谢各位了
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;namespace LoginApp
{
    public partial class frmChange : Form
    {
        public frmChange()
        {
            InitializeComponent();
        }        private void btnOK_Click(object sender, EventArgs e)
        {
            
            if (txtOldPwd .Text ==""||txtNewPwd .Text ==""||txtNewPwd2 .Text =="")
            {       
                if (MessageBox.Show("      您输入的信息不完整!,是否关闭窗口", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)     
                {        
                    this.Close(); 
                }      
            }   
            else  
                if (txtNewPwd.Text !=txtNewPwd2 .Text ) 
            {            
                if (MessageBox.Show("     您的新密码输入不一致!,是否关闭窗口", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)     
                {         
                    this.Close(); 
                }            
            }
                
            else 
                    if (txtOldPwd .Text !="")
                {
                    string connString = Properties.Settings.Default.connString;
                    OleDbConnection connection = new OleDbConnection(connString);
                    string sq1 = "select password from users where username='admin'";
                    OleDbDataAdapter OleDbDataAdapte1 = new OleDbDataAdapter(sq1, connString);
                    DataSet dt1 = new DataSet();
                    OleDbDataAdapte1.Fill(dt1, "users");
                    string sq2 = txtOldPwd.Text;
                    string sq3 = (string)dt1.Tables["users"].Rows[0]["password"];
                    if (sq2 .Equals (sq3 .Trim ()) && txtNewPwd .Text ==txtNewPwd2 .Text )
                    {
                        string constr1 = Properties.Settings.Default.connString;
                        string sq4 = "UPDATE users set password ='" + txtNewPwd.Text.Trim() + "' where username='admin'";
                        OleDbConnection conn = new OleDbConnection(connString);
                        conn.Open();
                        OleDbCommand cd = new OleDbCommand(sq4,conn );
                        OleDbDataReader sr = cd.ExecuteReader();
                        MessageBox.Show("密码已修改成功    ", "提醒");
                    }
                }
        }       
    }
}
C#密码

解决方案 »

  1.   

    程序有三个textbox 分别叫txtOldPwd用来写原密码还有叫txtNewpwd用来写新密码还有个叫txtNewpwd2用来判断新密码是否一致。代码写好了。程序就报错UPDATE语句错误
      

  2.   

    sql中password是关键字
    =>
    [password]
      

  3.   

    cd.ExecuteNonQuery()
    MessageBox.Show("密码已修改成功    ", "提醒");
      

  4.   

    按照3楼方法提示:无法将类型“int”隐式转换为“System.Data.OleDb.OleDbDataReader”怎么办