datamaintain.aspx

来自「用VB实现」· ASPX 代码 · 共 50 行

ASPX
50 行
字号 
<%@ Page Language="VB" ContentType="text/html" ResponseEncoding="gb2312" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<script runat="server">
    Dim strConn as String =  _ 
		           "Provider=Microsoft.Jet.OLEDB.4.0;" & _
				   "Data Source=" & Server.MapPath(".../bin/sales.mdb") & ";" & _
				   "Persist Security Info=False"
	Dim objConn as  New System.Data.Oledb.oledbConnection(strConn) 
	
	Sub btnUpdate_Click(sender As Object, e As System.EventArgs)
	    Dim strSQL as String  =  _ 
		    "Update Products Set UnitPrice = " & txtUnitPrice.Text  & " " & _ 
			"Where ProductID  = " & txtProductID.Text
		Dim ObjComm as New System.Data.Oledb.OleDbCommand(strSQL,objConn)
		
		objConn.Open()
		ObjComm.ExecuteNonQuery
		objConn.Close() 
			
	End Sub 
	
	Sub btnDelete_Click(sender As Object, e As System.EventArgs)
	    Dim strSQL as String  = "Delete From Products Where ProductID  = " & txtProductID.Text
		Dim ObjComm as New System.Data.Oledb.OleDbCommand(strSQL,objConn)
		
		objConn.Open()
		ObjComm.ExecuteNonQuery
		objConn.Close() 
			
	End Sub 
</script>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>商品资料维护</title>

</head>
<body>
<form runat="server">
 <asp:Label ID="lblProductID" runat="server" Text="商品编号"></asp:Label>
 <asp:TextBox ID="txtProductID" runat="server" />
 <br>
 <asp:Label ID="lblUnitPrice" runat="server" Text="商品单价"> </asp:Label>
 <asp:TextBox ID="txtUnitPrice" runat="server" />
 <asp:Button ID="btnUpdate" Text="更新" runat="server"  OnClick="btnUpdate_Click"/>
 <asp:Button ID="btnDelete" Text="删除" runat="server"  OnClick="btnDelete_Click"/> 
</form>
</body>
</html>

datamaintain.aspx - 源码说明

本页面展示了「用VB实现」中的 datamaintain.aspx 源码文件，采用 ASPX 编程语言编写，共 50 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫开发者社区收录了大量与VB相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?