温馨提示:代码在线浏览功能只能做为源码浏览参考,如果想更进一步了解该代码请下载:汽车配件公司网站(VB.net+Access数据库)源码
当前文件:
VbNetCompany/del_order.aspx.vb,打开代码结构图
VbNetCompany/del_order.aspx.vb,打开代码结构图1Imports System 2
Imports System.Data 3
Imports System.Configuration 4
Imports System.Collections 5
Imports System.Web 6
Imports System.Web.Security 7
Imports System.Web.UI 8
Imports System.Web.UI.WebControls 9
Imports System.Web.UI.WebControls.WebParts 10
Imports System.Web.UI.HtmlControls 11
Imports System.Data.OleDb 12
13
Public Partial Class del_order 14
Inherits System.Web.UI.Page 15
Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) 16
If Session("loginname") Is Nothing OrElse Session("loginname").ToString() = "" Then 17
Response.Write("<script>alert('用户登录时间超时,请重新登录');document.location='admin.aspx'</script>") 18
Response.[End]() 19
End If 20
Try 21
22
Using oleconn As New OleDbConnection() 23
oleconn.ConnectionString = ConfigurationManager.ConnectionStrings("oleConnectionString").ConnectionString 24
oleconn.Open() 25
Dim strSQL As String = "delete from orderlist where id=" + Request("id") 26
Dim command As New OleDbCommand(strSQL, oleconn) 27
command.ExecuteNonQuery() 28
29
oleconn.Close() 30
oleconn.Dispose() 31
Response.Write("<script language='javascript'>window.confirm('订单已经成功删除!!');</script>") 32
Response.Write("<script language='javascript'>document.location='vieworder.aspx';</script>") 33
End Using 34
Catch err As Exception 35
Dim str As String = err.Message.Replace("'", "") 36
Response.Write("<script>alert('" + str + "');</script>") 37
End Try 38
End Sub 39
End Class






