How to use WHILE in ASP.NET
<p>When retrieving 5 values using <code>LIMIT 0,5</code> and <code>WHILE</code> how to set these five values in five different ASP.NET text boxes? using the following code I am able to write as <code>Response.Write</code> but how to fix them in TextBox?</p>

<pre><code>OdbcCommand cmd = new OdbcCommand(
    "Select nickname, city, country, zipcode from awm_profiles WHERE email LIKE '%softmail.me%' LIMIT 0 , 30",
     MyConnection);

OdbcDataReader dr = cmd.ExecuteReader();
if (dr.HasRows == false)
{
    //throw new Exception();
}

while (dr.Read())
{
    string a = dr[0].ToString();
    string b = dr[1].ToString();
    string c = dr[2].ToString();
    string d = dr[3].ToString();
    Response.Write(a);
    Response.Write(b);
    Response.Write(c);
    Response.Write(d);
 }
</code></pre>
