So, how to get the selected record from List Products.asp appear on Update Product.asp. It will appear in a text box for each field.
Here what is contain in database.
Table: Products
Field: Product ID, Product Name, Product Price
Below is code for List Products.asp
Expand|Select|Wrap|Line Numbers
- <%language="javascript"%>
- <html>
- <body>
- <% var DSN="DSN=Bakery";
- var Conn = Server.CreateObject("ADODB.Connection");
- Conn.Open(DSN);
- sql="SELECT * from Products";
- rs=Server.CreateObject("ADODB.Recordset");
- rs.Open(sql,Conn);
- out+="<table border=1>"
- out +="<tr><td>Product ID</td><td>Product Name</td><td>Price</td></tr>";
- while(!(rs.EOF))
- {
- out +="<tr><td><%rs("Product ID")%></td><td><%rs("Product Name")%></td><td><%rs("Product Price")%></td><td><a href="Update Product.asp"></a></td></tr>"
- rs.move(1);
- }
- out +="</table>"
- rs.Close();
- Response.write(out);
- %>
- </body>
- </html>