We help IT Professionals succeed at work.

bind query results to a textbox

running32
running32 asked
on
Medium Priority
246 Views
Last Modified: 2012-05-05
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
Comment
Watch Question

Software Engineer
Commented:
after your execute reader statement..

while objReader.Read
  txtbox1.text=objReader(0)
 txtbox2.text=objReader(1)        //You will do this as per the number of columns your query results..
.....
....

end while

objReader.Close()
objConn.Close

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

Commented:
I get objreader not declared.  Thanks

Author

Commented:
Sorry go it, great, thanks
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.