C#中使用MySqlDataReader实现验证登录

        private void button1_Click(object sender, EventArgs e)
        {
            string username = txt_userName.Text;
            string password = txt_passWord.Text;
            string connetStr = ConfigurationManager.ConnectionStrings["connStr"].ConnectionString;

            using (MySqlConnection conn = new MySqlConnection(connetStr))
            {
                conn.Open();
                string sql = $"select userName,passWord from user where userName='{username}' and passWord='{password}';";
                MySqlCommand cmd = new MySqlCommand(sql, conn);

                using (MySqlDataReader reader = cmd.ExecuteReader())
                {
                    if (reader.HasRows)
                    {
                        MessageBox.Show("登录成功");
                    }
                    else
                    {
                        MessageBox.Show("用户名或密码错误");
                    }
                }
            }
        }

使用using可以自动释放资源

reader.HasRows检测是否读取到行