display a specific column in sql to a textbox asp.net
<p>What i want to do is to get a specific column in my database. Currently i have ID, Username, Lastname, Firstname, Email, CreditRequest and Contact. I want credit request column to be displayed in my asp textbox. Any tricks you can share?</p>

<p>i am thinking something like this:</p>

<pre><code>using (SqlConnection scn = new SqlConnection("Data Source = 'PAULO'; Initial Catalog=ShoppingCartDB;Integrated Security =True"))
{
    scn.Open();
    SqlCommand cmd = new SqlCommand("SELECT CreditRequest FROM CreditRequests WHERE Username=@Username", scn);
</code></pre>