transferring record from one asp file to another

puT3

I have a asp file which contain all recordset from access database in a table (List Products.asp). At each row there is a link which will open another file (Update Product.asp). The open file will contain record that is selected from List Products.asp.

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>

I need help to create the sql for Update Product.asp and how to transfer record from List Products.asp to Update Product.asp

codegecko

Hi puT3,

Your "Update Product.asp" file should simply be able to accept a querystring parameter so then you can do this:

Expand|Select|Wrap|Line Numbers

 
Integer iProduct = CInt(Request.QueryString("pid"))

' Then declare your SQL as:

strSQL = "SELECT * FROM Product WHERE ProductID = " & iProduct

That'll then grab the individual product record from the table.
Now to actually pass the product ID to that page, you have to change the hyperlink in "List Products.asp" to read this:

Expand|Select|Wrap|Line Numbers

 
out +="<tr><td><%rs("Product ID")%></td><td><%rs("Product Name")%></td><td><%rs("Product Price")%></td><td><a href="Update Product.asp?pid=<%rs("Product ID")%>"></a></td></tr>"

Note that your Product ID has now been appended to the end of the URL as a parameter called "pid", which the Request.QueryString method in the Update Product.asp file can read and subsequently use to query your DB.

Hope this helps.

codegecko

transferring record from one asp file to another

re: transferring record from one asp file to another

Similar ASP / Active Server Pages bytes

/bytes/development

/bytes/it

/bytes/about