modifypassword.cs

用于超市信息管理的系统

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace 超市信息管理系统.MarketSystem
{
    public partial class ModifyPassword : Form
    {
        private DataRow LogRow;
        public ModifyPassword()
        {
            InitializeComponent();
        }

        private void ModifyPassword_Load(object sender, EventArgs e)
        {
            label1.Text = Login.strUser + "你好!"+"\t"+"为了安全,请注意密码的安全性!!";
        }

        private void button1_Click(object sender, EventArgs e)
        {
            string StrSQL = "select * from SysUser";
            string sql = "update sysuser set userPwd='" + textBox2.Text.Trim() + "'where userID='"+Login.strUser+"'";
           SqlConnection myConnection = DataBaseConnection.connection();
           SqlDataAdapter da;
           DataSet ds = new DataSet();
           DataTable LogTable;
           da = new SqlDataAdapter(StrSQL, myConnection);
           ds.Clear();
           da.Fill(ds, "SyUser");
           LogTable = ds.Tables[0];
          
         try
         {
             for (int i = 0; i < LogTable.Rows.Count; i++)
             {
                 this.LogRow = LogTable.Rows[i];
                 //只有当输入的用户名和密码同时对应上数据库中记录时，才能通过校验
                 if (LogRow[0].ToString().Trim().Equals(Login.strUser) && LogRow[1].ToString().Trim() == this.textBox1.Text.ToString().Trim())
                 {
                     DataBaseConnection.update(sql);
                     MessageBox.Show("密码更新成功");
                     return;
                 }
             }
             MessageBox.Show("密码错误，请重新输入");
             return;
         }
         catch (SqlException oe)
         {
             MessageBox.Show(oe.Message);
         }
         finally
         {
             myConnection.Close();
         }
        }

        private void button2_Click(object sender, EventArgs e)
        {
            this.Close();
        }
    }
}