asp显示

         <%
                      dim rs1
                      Set rs1 = Server.CreateObject("ADODB.Recordset")
                      int userid=rs("userid")
                      sql1="select username from users where userid=" & cstr(rs("userid"))
                      'response.write(sql1)
                      rs1.open sql1,conn,1,1
                      %>
                      <label><label><% =rs1("username")%></label></label>

   我想通过调用users表中的id 来显示 users表中 username项的信息 但是为什么行不通呢，还请大家帮忙一下 谢谢！！！