Assigning values from database to a textbox or label control in ASP.net

Question

hi buddies, I want to assign text values of database table(example: login_table contains test value in username column & set this test to textbox or label)to a Textbox or a Label. Any code or snippets will be appreciated. Pls do help. Thx in advance.