Ask Me Help Desk - Dreamweaver MX: ASP.NET creating art gallery

I am creating a web art gallery. The problem I am having at the moment is that I want to link members on the site to their gallery page.

I have a page with members name on them. I want to link those names to a single gallery page. Depedning on what name I pressed on, I want the gallery page to change to display that members art.

Furthermore at the top of the page there will be another table that will display the member profile and name according to the name that was pressed.

I am using DWMX, IIS, ASP.NET, MS Access. I have linked to the page using OLEDB and I have two datasets one for members details and the second for picture details.

Please can someone tell me how this can be done.

Haven't touched ASP for years, so I can't be detailed but here's what you need to do.

On the page with all the members names, you want the link to the gallery page to be something like <a href="gallery.asp?name=memberID">. To do this you'll need a loop that loops through each member's details, creating a link using their name/id/whatever you are using as a primary key on the members table.

Then on the gallery page you will need to retrieve the value of memberID from the querystring. Can't remember the ASP syntax to do this :(

Then use this value to peform an SQL query retrieving the data just for that member. I.e. for the table at the top with the member details - "Select * from members where memberID = '"+ memberID +"';"

That's basically how you do it. Hopefully some of the other experts can fill in the syntax gaps. If not, I'll do it when I get home tonight (if I remember).

Sorry for the late peply.

I understand what you mean by using the member number in otder to relate the member list to the galley. But since I am new to ASP.NET could be describe in details what synataxs I should use and where in the script page I should put it.

Sorry for the inconvienence.

Sorry it's taken me a long time to reply. OK, here's my understanding of how it would be done (remember I've not done ASP for years so it may be slightly incorrect)

First Page - Shows member names

Code:

<html> <head> <title>Members</title> </head> <body> <% ' Create Connection and Recordset objects Set Conn = Server.CreateObject("ADODB.Connection") Set Rs = Server.CreateObject("ADODB.RecordSet") ' Open the connection to the ODBC source, in this case ' the Access database Conn.Open "your_ODBC_source" ' Now, create the SQL statement SQL = "SELECT id, name FROM tbl_member" ' Execute the SQL statement to get a recordset Set Rs = Conn.Execute(SQL) ' While records remain in the record set Do While NOT Rs.EOF ' Print out a link for the current member Response.Write("<a href=""gallery.asp?id="& Rs.Fields("id").value &""">"& Rs.Fields("id").value &"</a>") ' Move to the next record Rs.MoveNext Loop ' Tidy Up Rs.Close Set Rs = Nothing Conn.Close Set Conn = Nothing %> </body> </html>

Page 2 - Gallery

Code:

<html> <head> <title>Members</title> </head> <body> <% ' Retrieve the user's ID. You'll want this to retrieve the users data userID = Request.QueryString("id") ' Create Connection and Recordset objects Set Conn = Server.CreateObject("ADODB.Connection") Set Rs = Server.CreateObject("ADODB.RecordSet") ' Open the connection to the ODBC source, in this case ' the Access database Conn.Open "your_ODBC_source" ' Now, create the SQL statement SQL = "SELECT * FROM tbl_gallery WHERE memberID = "& userID ' Execute the SQL statement to get a recordset Set Rs = Conn.Execute(SQL) ' While records remain in the record set Do While NOT Rs.EOF ' ' Do whatever you want with the data here! ' ' Move to the next record Rs.MoveNext Loop ' Tidy Up Rs.Close Set Rs = Nothing Conn.Close Set Conn = Nothing %> </body> </html>

This was all pieced together off another website so sorry if it's inconsistent etc.

Thanks for the reply. I tried using your code for my website and it worked. Thanks