View Full Version : Passing client details

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 ?

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")