labe如何读取数据库前几条记录

[shaman945]

各位好心人，我想把第一条记录的username放到labe1.Text中，因为怎么写呀
string sql = string.Format("select top 2 username,password from uuser where username = '{0}' and password = '{1}'", uid.Text, upwd.Text);
SqlDataReader sdr = DBhelp.GetReader(sql);
if (sdr.Read())
{
labe1.Text = ?
}

[sundotLei]

if (sdr.Read())
{
labe1.Text = sdr["username"].ToString();
}

如果返回多条记录的话，label.text的值将是最后一条记录的username

[十八道胡同]

sdr["username"].ToString();

[yuquanzuo]

labMotifName.Text = SqlDataReader ["username"].ToString();

[qq18527575]

sdr["username"].ToString();

[walkghost]

string sql = string.Format("select top 2 username,password from uuser where username = '{0}' and password = '{1}'", uid.Text, upwd.Text);
          using(SqlDataReader sdr = DBhelp.GetReader(sql)){
           try{
                if (sdr.Read())
                {
                  labe1.Text =sdr["username"].ToString().Trim();
                }
           }
           catch(Exception ex)
           {
               //do sth...
           }
           finally
           {
               sdr.Close();//关闭Reader
           }
          }

[mytimes_walker]

sdr.GetString(0)