vs2008和sql2005查询显示在label里面出问题？新手求教

Question

本帖最后由 sq5945 于 2011-11-24 12:50:36 编辑

Answer 1

if (sdr.Read())
 {
  this.lblyhname.Text = sdr.GetString(1);
 }

Answer 2

string UserId = Request["UserId"];
        using (SqlConnection con = DB.createDB())
        {
            con.Open();
            string strSQL = "select * from tb_Users where UserId=' " + UserId + "'";
            using (SqlCommand cmd = new SqlCommand(strSQL, con))
            {
                SqlDataReader sdr = cmd.ExecuteReader();
                if (sdr != null)
                {
                    if (sdr.Read())
                    {
                        this.lblyhname.Text = sdr.GetString(1);
                        this.lblyhpwd.Text = "* * *";
                        this.lblywname.Text = sdr.GetString(3);
                        this.lblyhyx.Text = sdr.GetString(4);
                        this.imgtouxiang.ImageUrl = sdr.GetString(5);
                    }
                }
                else
                {
                    //
                }
            }
        }

Answer 3

楼上的两位那样改了代码貌似没有数据进去啊，label还是为空！！