private void button1_Click(object sender, EventArgs e)
        {
            SqlCommand cmd = new SqlCommand("select * from admin where adminuser='" + textuser.Text + "'", conn);
            conn.Open();
            SqlDataReader sdr = cmd.ExecuteReader();
            if (sdr.Read())//选择语句
            {
                if (sdr["adminpwd"].ToString() == textpwd.Text)
                {

                    FromMain main = new FromMain();
                    main.Show();
                    this.Hide();
                }
                else
                {
                    MessageBox.Show("密码错误!");
                }
            }
            else
            {
                MessageBox.Show("无此用户!");
            }
            conn.Close();
        }




输入帐号正确   输入正确、错误密码 一定会出现  MessageBox.Show("密码错误!");   这个框框的


何解呢？帮忙看下~~谢谢啦

哦  我错了  

if (sdr["adminpwd"].ToString() == textpwd.Text)

这一句如果我想换成读取数据表

数据库是SQL2005

我意思是 我要读取  admin表的  adminpwd这一列数据去跟textpwd.Text比较  该怎么改？


 谢谢楼上了~~