您目前尚未登陆,请选择【登陆】或【注册
首页->留言本类->晶晶Vb.net留言板源码>>del.aspx>>源码在线查看
温馨提示:代码在线浏览功能只能做为源码浏览参考,如果想更进一步了解该代码请下载:晶晶Vb.net留言板源码
当前文件:文件类型 VbGuestBook/del.aspx打开代码结构图
普通视图
		            
1<%@ Import namespace="system.data.oledb" %> 2<%@ Import namespace="system.data" %> 3<%@ Page Language="vb" AutoEventWireup="false"%> 4<% 5 If Session("name") <> ConfigurationSettings.AppSettings("站长") Then Response.Redirect("default.aspx") 6 Dim ID As String, page As String, conn As OleDbConnection, comd As OleDbCommand, dr As OleDbDataReader 7 Dim theTime As Date 8 ID = Request.QueryString("ID") 9 page = Request.QueryString("page") 10 If ID = "" Or IsNumeric(ID) = False Then Response.redirect("default.aspx") 11 conn = New OleDbConnection("Provider=Microsoft.Jet.Oledb.4.0;Data Source=" & Server.MapPath(ConfigurationSettings.AppSettings("数据库"))) 12 comd = New OleDbCommand("Select 时间 From 留言 Where ID=" + ID, conn) 13 comd.Connection.Open() 14 dr = comd.ExecuteReader 15 If dr.Read Then 16 theTime = dr(0) 17 Else 18 Response.Redirect("default.aspx") 19 End If 20 comd.Connection.Close() 21 comd.CommandText = "Delete From 留言 Where ID=" + ID 22 comd.Connection.Open() 23 comd.ExecuteNonQuery() 24 comd.Connection.Close() 25 comd.Dispose() 26 conn.Close() 27 conn.Dispose() 28 Dim ds As DataSet = New DataSet() 29 ds.ReadXml(Server.MapPath("data\count.xml")) 30 If DateValue(theTime) = DateValue(ds.Tables(0).Rows(0)(4)) Then ds.Tables(0).Rows(0)(0) = CInt(ds.Tables(0).Rows(0)(0)) - 1 31 ds.Tables(0).Rows(0)(2) = CInt(ds.Tables(0).Rows(0)(2)) - 1 32 ds.Tables(0).Rows(0)(4) = Date.Now 33 ds.AcceptChanges() 34 ds.WriteXml(Server.MapPath("data\count.xml")) 35 ds.Clear() 36 ds.Dispose() 37 Response.Redirect("default.aspx?page=" + page) 38%> 39
还没有找到您心仪的内容?请用.net源码大搜捕
代码片断 打包下载该项目完整源码:晶晶Vb.net留言板源码
51Aspx.com 版权所有 CopyRight © 2000-2008. 京ICP备06046876号