Can this be done?

timothy.farrell

I have a aspx page that queries a db and generates a list of records. The db has some 15 or so columns so I have only queried for 7 of the columns in my results page. The question I have is: Is there a way I can have the first field data be a link to the full data details for that record? In other words, say I have a database of demographic data for users. I have a scaled down list of records from that db that only contains NAME, DEPT, COMPANY. I want to have each name be a link to further details about that user. So if you clicked on Smith, John then you would get other details about their record such as name, email, phone, dept, company, address, zip. Thank you for your thoughts. Sincerely, Tim

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

timothy.farrell22y ago
Awesome, this is exactly what I was talking about. Can you direct me to a link that may give additional details on how to configure this? Currently the data is coming from a dataReader. Should I change this to a dataset instead? Thank you for your help!!! Sincerely, Tim
jdrocks5722y ago
It seems to me there's two ways of going about this. Either you present the list of users, and upon selecting a user, go back to the DB to get the other data. Or, just get all the data for each user via a table within a dataset. Get the datatable from the dataset, store it in memory. Populate a datagrid with the required user data (Name, Dept, etc...). Have linkbutton in the datagrid for each row. When the user selects the linkbutton, get the row index number in the datagrid specifing which row the user clicked on. Get that datatable from memory and find the corosponding row with in that datatable using the row index number you just got. Get the row data from the datatable that's in memory. Display the data. You have decide whether the amount of data you would store in memory representing the datatable doesn't cause problems. Remember to factor in the number of potential users at any one given time as well.