Simple Binding Of Text Box Control

Hi,

 I have a really simple question.  I have a web form with a couple text boxes and check boxes.  I want to get data from my DB and set the values to the controls.  Right now this is how my code looks:

--------------------------------------------------------------------------------------- Dim cmdSelect As Data.SqlClient.SqlCommand

 Dim CnDB As Data.SqlClient.SqlConnection

Dim strSQL As String

'Build Select StatementstrSQL = "Select LoginName, UserName, [Status] " & _

"FROM SmallToolSystemUser " & _"WHERE LoginName = '" & strLoginName & "' " & _

"AND UserID = " & intUserID & " "

'I must take the connection string and put it back in the web.config file. For now i am having problems getting it from thereCnDB = New Data.SqlClient.SqlConnection("Data Source=ORION;Initial Catalog=eisTEST;Persist Security Info=false;User ID=User;Password=password")

Try

CnDB.Open()Catch ex As Exception

Response.Write("Cannot open the database connection ")

Exit Sub

End TrycmdSelect = New Data.SqlClient.SqlCommand(strSQL, CnDB)

cmdSelect.CommandType = Data.CommandType.Text

------------------------------------------------------------------------------------------------

I am a classic ASP guy so I am used to recordset and old text1.text = RS("value") approach.  I have done some work in ASP.Net 1.0 and my code in there used datareaders.  Can someone give me some guidance here.

 

Much appreciated