下拉列表属性

本文关键字:属性 下拉列表 | 更新日期: 2023-09-27 18:06:50

我想知道是否有人能给我指出正确的方向。我的程序有1个下拉列表,2个文本框和2个按钮。

namespace passwordReset
{
    public partial class Form1 : Form
    {
        //variables to mess with the password
        public string password1;
        public string password2;
        public string username;
         public Form1()
        {
            InitializeComponent();
        }
        private void Form1_Load(object sender, EventArgs e)
        {
            SqlConnection connection = new SqlConnection(xxxxxxx);
            connection.Open();
            string query = "select Login, Password from Employees order by Login desc";
            SqlDataAdapter da = new SqlDataAdapter(query, connection);
            DataSet ds = new DataSet();
            da.Fill(ds, "Credentials");
            ddlLogin.DisplayMember = "Login";
            ddlLogin.ValueMember = "Password";
            ddlLogin.DataSource = ds.Tables["Credentials"];
            connection.Close();
        }
        private void ddlLogin_SelectedIndexChanged(object sender, EventArgs e)
        {

            if (ddlLogin.SelectedItem != null)
           {
               DataRowView drv = ddlLogin.SelectedItem as DataRowView;
               //MessageBox.Show("The username you selected is: " + drv.Row["Login"].ToString());
               //MessageBox.Show("The password you selected is: " + drv.Row["Password"].ToString());
               //MessageBox.Show("username selected is: " + ddlLogin.Text.ToString());
               //MessageBox.Show("password is: " + ddlLogin.SelectedValue.ToString()); 
           }
        }
        private void txtPassword1_TextChanged(object sender, EventArgs e)
        {
             password1 = txtPassword1.Text;
        }
        private void txtPassword2_TextChanged(object sender, EventArgs e)
        {
             password2 = txtPassword2.Text;
        }
        private void btnReset_Click(object sender, EventArgs e)
        {
            if (ddlLogin.Text == "rruales" || ddlLogin.Text == "xxxxx" || ddlLogin.Text == "xxxxxx")
            {
                MessageBox.Show("Cannot change this user's password");
            }
            if (password1 == password2 && ddlLogin.Text != "rruales" && ddlLogin.Text != "xxxxx" && ddlLogin.Text != "xxxxx")
            {
                string newPassword = txtPassword2.Text;
                username = ddlLogin.Text.ToString();
                string currentPassword = ddlLogin.SelectedValue.ToString();
                currentPassword = newPassword;
                SqlConnection connection = new SqlConnection(xxxxxxxx);
                SqlCommand cmd = new SqlCommand();
                cmd.CommandType = CommandType.Text;
                cmd.CommandText = "UPDATE Employees SET [Password] = @password WHERE [Login] = @login";
                cmd.Parameters.AddWithValue("@password", currentPassword);
                cmd.Parameters.AddWithValue("@login", username);
                cmd.Connection = connection;
                connection.Open();
                cmd.ExecuteNonQuery();
                MessageBox.Show("Password successfully updated");
                connection.Close(); 

            }
            else
            {
                MessageBox.Show("You either choose usernames  rruales or xxxxx or xxxx, or the passwords don't match, try again");
            }
        }
        private void btnClose_Click(object sender, EventArgs e)
        {
            this.Close();
        }
    }
}

代码做了它需要做的事情,当用户从下拉菜单中选择用户名时,他们可以重置用户的密码。但如果用户输入想要重置的用户名,这里会出现错误:

string currentPassword = ddlLogin.SelectedValue.ToString();

错误提示对象引用未设置为对象的实例。使用"new"关键字创建对象实例。我理解错误来自于用户输入用户名而不是选择它的事实。我的问题是,我不需要代码,我想知道如何处理,用户只需要输入用户名或从下拉菜单中选择?任何建议重写代码是受欢迎的,我是一个入门级的开发人员。

更新,我不能回答我自己的问题,但它现在工作,感谢所有

,谢谢你的帮助。你说的都起作用了,我也不得不对我的代码做了一次修改,我意识到我做了一些非常愚蠢的事情:

    private void txtPassword1_TextChanged(object sender, EventArgs e)
    {
         password1 = txtPassword1.Text;
    }
    private void txtPassword2_TextChanged(object sender, EventArgs e)
    {
         password2 = txtPassword2.Text;
    }
    private void btnReset_Click(object sender, EventArgs e)
    {
        if (ddlLogin.SelectedValue == null)
        {
            username = ddlLogin.Text.ToString();
        }
        else
        {
            username = ddlLogin.Text.ToString();
        }
        if (ddlLogin.Text == "rruales" || ddlLogin.Text == "xxxxx" || ddlLogin.Text == "xxxxxx")
        {
            MessageBox.Show("Cannot change this user's password");
        }
        if (password1 == password2 && ddlLogin.Text != "rruales" && ddlLogin.Text != "xxxxxx" && ddlLogin.Text != "xxxxxx")
        {
            string newPassword = txtPassword2.Text;

            //username = ddlLogin.Text.ToString();
           // string currentPassword = ddlLogin.SelectedValue.ToString();

            currentPassword = newPassword;
            SqlConnection connection = new SqlConnection(xxxxxx);
            SqlCommand cmd = new SqlCommand();
            cmd.CommandType = CommandType.Text;
            cmd.CommandText = "UPDATE Employees SET [Password] = @password WHERE [Login] = @login";
            cmd.Parameters.AddWithValue("@password", currentPassword);
            cmd.Parameters.AddWithValue("@login", username);
            cmd.Connection = connection;
            connection.Open();
            cmd.ExecuteNonQuery();
            MessageBox.Show("Password successfully updated");
            connection.Close(); 

        }
        else
        {
            MessageBox.Show("You either choose usernames  rruales or xxxxx or xxxx, or the passwords don't match, try again");
        }
    }
    private void btnClose_Click(object sender, EventArgs e)
    {
        this.Close();
    }
}

}

我不知道我为什么这样做:

string currentPassword = ddlLogin.SelectedValue.ToString();

下拉列表属性

如果你没有从下拉菜单中选择一个项目,它的SelectedValue将为null。你应该检查它是否为空。如果为空,则从文本框中获取值。

string userName;
if (ddlLogin.SelectedValue == null) {
    userName = theTextBox.Text; 
} else {
    username = theDropDownList.SelectedValue.Text;
}

我不确定这是不是你想要的用户名。您提到了当您输入用户名但从ddlLogin获取密码时抛出的异常?无论你想要赋值什么,只要检查下拉框是否像上面那样为空,然后赋值给正确的变量。