asp读取数据后进行添加修改删除操作
<
%
set rs = server.createobject( " adodb.recordset " )
sql = " select*frombranchlist "
rs.opensql,conn, 2 , 3
if not rs.eof then
' 添加新数据
rs.addnew
rs( " branchname " ) = " ccccc "
rs( " createtime " ) = now ()
rs.update
' 修改数据
rs( " branchname " ) = " newdate "
rs.update
rs.close
set rs = nothing
% >
set rs = server.createobject( " adodb.recordset " )
sql = " select*frombranchlist "
rs.opensql,conn, 2 , 3
if not rs.eof then
' 添加新数据
rs.addnew
rs( " branchname " ) = " ccccc "
rs( " createtime " ) = now ()
rs.update
' 修改数据
rs( " branchname " ) = " newdate "
rs.update
rs.close
set rs = nothing
% >