I am trying to populate a gridview control to display the current registered users on the site.
I query various tables from the ASPDOTNET.mdb database in order have a list comprising of UserNames, Email address, LastLoggedOn, etc. This bit is fine and it displays all the details.
The part I'm having a problem with, is I would like to add the FirstName and LastName to each row also. But I'm not sure how to get at the record. In the profile table I have a column with this detail within plus other personal details but I only need to retrieve the names and display that in the gridview.
ASP.Net version 3.5
Access Database provider ASPDOTNET.MDB
(setup exactly the same way as the sql express table structure.)
View Complete Post