数据库到lable标签

Question

我的代码是这样的
 protected void Button1_Click(object sender, EventArgs e)
    {
        string sql = string.Format("select username,password,email from uuser where username = '{0}' and password = '{1}'", yhm.Text , mm.Text);
                SqlDataReader sdr = DBhelp.GetReader(sql);
                if (sdr.Read())
                {
                    Label1.Text = ？
                }
    }
我想把查询到的这条记录中的随便一个字段放到lable标签中，请问各位大侠应该怎么写啊

Answer 1

Label1.Text =sdr["username"].ToString()

Answer 2

//一个实例
 if (dr.Read())
                {
                    this.Id = Convert.IsDBNull(dr["Id"]) ? 0 : Convert.ToInt32(dr["Id"]);
                    this.Orgid = Convert.IsDBNull(dr["orgId"]) ? 0 : Convert.ToInt32(dr["orgId"]);
                    this.OrgName = Convert.IsDBNull(dr["orgName"]) ? "" : dr["orgName"].ToString().Trim();
                    this.Deptid = Convert.IsDBNull(dr["Deptid"]) ? 0 : Convert.ToInt32(dr["Deptid"]);
                    this.DeptName = Convert.IsDBNull(dr["deptName"]) ? "" : dr["deptName"].ToString().Trim();
                    this.Xzzfrid = Convert.IsDBNull(dr["Xzzfrid"]) ? 0 : Convert.ToInt32(dr["Xzzfrid"]);
                    this.Email = Convert.IsDBNull(dr["Email"]) ? "" : dr["Email"].ToString().Trim();
                    this.Tel = Convert.IsDBNull(dr["Tel"]) ? "" : dr["Tel"].ToString().Trim();
                    this.Tel = Convert.IsDBNull(dr["Mobile"]) ? "" : dr["Mobile"].ToString().Trim();
                    this.Addtime = Convert.ToDateTime(dr["AddTime"]);
                    this.Endtime = Convert.ToDateTime(dr["Endtime"]);                    this.Lockstate = Convert.IsDBNull(dr["Lockstate"]) ? 0 : Convert.ToInt32(dr["Lockstate"]);
                    this.Delestate = Convert.IsDBNull(dr["Delestate"]) ? 0 : Convert.ToInt32(dr["Delestate"]);
                    this.Usertype = Convert.IsDBNull(dr["Usertype"]) ? 0 : Convert.ToInt32(dr["Usertype"]);
                    //this.Zjhm = Convert.IsDBNull(dr["Zjhm"]) ? "" : dr["Zjhm"].ToString().Trim();                    //this.Jgbm = Convert.IsDBNull(dr["Jgbm"]) ? "" : dr["Jgbm"].ToString().Trim();
                    //this.Jgjc = Convert.IsDBNull(dr["Jgjc"]) ? "" : dr["Jgjc"].ToString().Trim();
                    //this.Jgmc = Convert.IsDBNull(dr["Jgmc"]) ? "" : dr["Jgmc"].ToString().Trim();
                    //this.ZfrName = Convert.IsDBNull(dr["ZfrName"]) ? "" : dr["ZfrName"].ToString().Trim();
                    //this.Qxmc = Convert.IsDBNull(dr["qxmc"]) ? "" : dr["qxmc"].ToString().Trim();
                    retval = true;
                }
                if (!dr.IsClosed)
                {
                    dr.Close();
                }

Answer 3

Label1.Text =sdr["username"].ToString();