I am not sure if you are looking for code that does it for you. I can tell you the way of doing it. And not sure if you are looking for doing this using ASP / .Net, no mention about that.
1) declare variables for use.
2) Define Connectionstring to connect to your access db.
3) Open a connection to the db using the connectionstring defined.
4) Do a select on the table in question and show only the columns that are required.
5) Have a while loop that iterates through till the last records in the recordset.
6) Within the loop load the relevant columns in to correspondng variables.
7) Show the relavant columns on page.
8) For READ MORE link, pass the primarykey / ID sort of value that you sue in the table for every row.
9) Do not forget to close the connection/reset the recordset/connection objects etc...
When clicked on READ MORE,
1) Capture the primarykey value passed along with it and do similar steps to connect to table, query for that primarykey value based row from the table, and show up that on the page as mentioned above. But in this case, you get just one row, so you wont need a loop sort for there.
Hope that helps.
_________________________
- Vijay G
Strive for Perfection
|
