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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Sorry go it, great, thanks
ASKER