<%Dim CategoryDim DescriptionDim cnCategory = request.form("txtCategory")Description = request.form("txtDescription")catID = request.form("txtID")strSQL="UPDATE Categories SET CategoryName='" & Category & "'",Description='" & Description & "'"strSQL = strSQL & " WHERE CategoryID =" & CatIDset cn = Server.CreateObject("ADODB.Connection")cn.Open "NorthWindDSN"cn.Execute(strSQL)Response.write "You have successfully amended a record."cn.CloseSet cn = nothing%>

Click Next for delete.asp