Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    New Coder
    Join Date
    Mar 2012
    Posts
    33
    Thanks
    6
    Thanked 1 Time in 1 Post

    Passing client details

    I have a asp.net site build. With an access database

    What I would like to do is once the user logs on with his user name and password how could I get his details from
    The access database into the contact text boxes on page load ?

  • #2
    Senior Coder alykins's Avatar
    Join Date
    Apr 2011
    Posts
    1,930
    Thanks
    46
    Thanked 203 Times in 202 Posts
    access connection strings and then it would be simple access select statements and returning-

    select [userAddL1],[userAddL2],[City],[StateCD],[Zip]
    from tbl_userDetails where [userFName] = @fName and [userLName] = @lName
    *** fill a datatable with above info...
    txtbx_UserAddL1.Text = dt.Rows(0)("userAddL1")
    etc...

    I code C hash-tag .Net
    Reference: W3C W3CWiki .Net Lib
    Validate: html CSS
    Debug: Chrome FireFox IE


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •