At kunne redigere er meget let først laver du en side der henter dine data ind så det sår in input felterne når siden åbnes derester kan du ændre dem om sende dem viddere ove rtil en anden side der så opdaterer.
Her er der et eksempel
Siden skal have et ID numemr som input det er ID nummeret på den takel nu ænsker at redigere i
f.eks edit.asp?ID=1
edit.asp
---------------------------------------
<%
sID = request("ID")
Set rs = Server.CreateObject("ADODB.RecordSet")
strSQL = "SELECT * FROM [cd] WHERE (ID = " & sID & ")"
strDSN = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ="&Server.MapPath("cd.mdb")
rs.Open strSQL, strDSN, 1
%>
<form method="POST" action="update.asp">
<head>
<title></title>
</head>
<body topmargin="0">
<p align="center"><input type="hidden" name="ID" size="20" value="<%=rs("ID")%>"><img border="0" src="logo.gif"></p>
<p align="center"> </p>
<p align="center">
Change the Data of the Record.
<hr width="57%"color="#0000FF">
<p align="center"><input type="text" name="Nummer" size="20" value="<%=rs("Nummer")%>"></p>
<p align="center"><input type="text" name="Navn" size="20" value="<%=rs("Navn")%>"></p>
<p align="center"><input type="submit" value="Update" name="B1"><input type="reset" value="Reset" name="B2"></p>
<hr width="57%"color="#0000FF">
</form>
<p align="center">[<a href="admin.asp">Admin</a>]</p>
<%
rs.Close
Set rs = Nothing%>
Her er så siden der opdatere det hele
update.asp
-------------------------------------
<%
ID = Request("ID")
Nummer = Request("Nummer")
Navn = Request("Navn")
'Response.Write "!" & Request.querystring("ID")
'ID="14"
Set rs = Server.CreateObject("ADODB.RecordSet")
strSQL = "SELECT * FROM [cd] WHERE (ID = " & ID & ")"
strDSN = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ="&Server.MapPath("cd.mdb")
rs.Open strSQL, strDSN, 1,3
rs("Nummer") = Nummer
rs("Navn") = Navn
rs.Update
rs.Close
Set rs = Nothing
%>
<head>
<title></title>
</head>
<meta http-equiv="Refresh" content="5;URL=admin.asp">
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<body topmargin="0">
<p align="center"><img border="0" src="logo.gif" width="412" height="100"></p>
<p align="center"> </p>
<hr width="57%"color="#0000FF"><br>
<div align="center">
<center>
<table border="1" width="53%">
<tr>
<td width="100%" colspan="2">
<p align="center">
The Record with the ID <%=ID%> have been changed to.</td>
</tr>
<tr>
<td width="15%">
CD Number :</td>
<td width="54%"><%=Nummer%></td>
</tr>
<tr>
<td width="15%">
Name :</td>
<td width="54%"><%=Navn%></td>
</tr>
</table>
</center>
</div><br>
<hr width="57%"color="#0000FF">
<p align="center">[<a href="admin.asp">Admin</a>]</p>
Ny bruger
Nybegynder
Opret
Preview
