Link to home
Start Free TrialLog in
Avatar of running32
running32

asked on

bind query results to a textbox

I have a query which runs on my asp page to retrive a row of data.  I would like to write out the information to textboxes. How can I do that please.

Sub Page_Load()
      If Not IsPostBack Then
            BindData()
      End If
End Sub

Sub BindData()
'dim currentdate as date
dim id = (request.params("recordid"))
objConn.Open()

      objCmd.CommandText = "select timein, timeout from employeehours where recordid = 24"

objCmd.Connection = objConn
objRdr = objCmd.ExecuteReader()


End Sub
ASKER CERTIFIED SOLUTION
Avatar of Raju Srivatsavaye
Raju Srivatsavaye
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of running32
running32

ASKER

I get objreader not declared.  Thanks
Sorry go it, great, thanks