...

View Full Version : Passing client details



dave_UK
03-28-2012, 02:01 AM
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 ?

alykins
03-28-2012, 02:46 PM
access connection strings (http://www.connectionstrings.com/access) 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...



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum