data.asp

基于C#语言的一个物流信息网数据库系统开发案例的源代码 ,很实用

<!-- #include file="../../Conn/conn.asp" -->
<% 
	title=request.form("title")
	content=request.form("content")
	sql="select * from tb_HelpMeg where Title='"&title&"'"
	rs.open sql,conn
	if not rs.eof or not rs.bof then 
%>
		<script language="javascript">
			alert("同标题信息已经存在，请更改标题或将同标题信息删除后再重新保存!");
			history.back();
		</script>
<% 
		set rs=nothing
		conn.close
		set conn=nothing
%>
<% 	else %>
<!-- #include file="../../Conn/conn.asp" -->
<% 
		sql="insert into tb_HelpMeg values('"&title&"','"&content&"','"&Date()&"')"
		rs.open sql,conn
		set rs=nothing 
		conn.close
		set conn=nothing
%>
<!-- #include file="../../Conn/conn.asp" -->
<%
		sql="select * from tb_HelpMeg where Title='"&title&"'"
		rs.open sql,conn
		if rs.eof or rs.bof then 
%>
			<script language="javascript">
				alert("保存失败，请重新保存");
				history.back();
			</script>
<%		 else %>
				<script language="javascript">
					alert("帮助信息保存成功");
					window.close();
					opener.location.reload();
				</script>
<% 		end if %>
<% end if %>