memberdata_mod_save.asp

客户管理系统使用ASP.NET和Access

<!--#include file="conn.asp"-->
<!--#include file="islogin.asp"-->
  <%
     tel=request.form("tel")
     fen=request.form("fen")
     mob=request.form("mob")
     qq=request.form("qq")
     ali=request.form("ali")
     email=request.form("email")
	if tel="" or fen="" then 
    response.Write"<script language=Javascript>alert('电话和分机号码不能为空！');" 
    response.write"javascript:history.go(-1)</script>" 
    response.end 
    end if
	set rs=server.createobject("adodb.recordset")
     sql="select * from Member where id="&session("Memberid")
     rs.open sql,conn,1,3
    rs("tel")=tel
    rs("fen")=fen
    rs("mob")=mob
    rs("qq")=qq
    rs("ali")=ali
    rs("email")=email
    rs.update
    rs.close
    set rs=nothing
    conn.close
    set conn=nothing
 response.Write("<script>alert('成功修改！')</script>")
 response.Write("<script>opener.location.reload()</script>")
 response.Write("<script>javascript:window.close()</script>")
 %>