ASP read database records

<%
'
Dpath = "Www.111cn.net/dbasemateydbweb_^%$#@.mdb"
Set conn=server.createobject ("Adodb.connection")

If request. QueryString ("action") = "List" Then
Set Rs =server.createobject ("Adodb.recordset")
conn.connectionstring= "Provider=Microsoft.Jet.OLEDB.4.0;Data source=" &server.mappath (Dpath)
Conn.Open
Dim SQL

sql = "SELECT * FROM Test id=" &request. QueryString ("id")
Rs.Open sql,conn,1,3

End If

%>

<input name= "UID" type= "text" id= uid "value=" <%=rs ("UID")%> ">

User name

<input name= "pwd" type= "text" id= "pwd" value= "<%=rs (" pwd ")%>" >

Password

</p>
<table width= "361" border= "0"
  <tr>
    <td width= "265" > Address </td>
    <td width= "*" > Operation </td>
  </tr>
  <TR
    <td>www.111cn.net</td>
    <td><a href= "? id=2" > View </a></td>
  </tr>
</table>
<p> This article was originally reproduced in www.111cn.net reprint of the source </p "