data.asp

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

<!-- #include file="../../Conn/conn.asp" -->
<% 
	title=request.form("title")
	content=request.form("content")
	reside=request.Form("reside")
	sql="select * from tb_KnowLedgeMeg where Title='"&title&"' and Reside='"&reside&"'"
	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_KnowLedgeMeg values('"&title&"','"&content&"','"&Date()&"','"&reside&"')"
	rs.open sql,conn
	set rs=nothing 
	conn.close
	set conn=nothing
%>
<!-- #include file="../../Conn/conn.asp" -->
<%
	sql="select * from tb_KnowLedgeMeg where Title='"&title&"' and Reside='"&reside&"'"
	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 %>