📄 sqlformdelete.aspx
字号:
<%@ Import Namespace="System.Data.SqlClient" %>
<Script Runat="Server">
Sub Button_Click( s As Object, e As EventArgs )
Dim conPubs As SqlConnection
Dim strDelete As String
Dim cmdDelete As SqlCommand
Dim intDeleteCount As Integer
conPubs = New SqlConnection( "Server=localhost;UID=sa;PWD=secret;database=Pubs" )
strDelete = "Delete Authors Where au_lname=@lastname"
cmdDelete = New SqlCommand( strDelete, conPubs )
cmdDelete.Parameters.Add( "@lastname", txtLastName.Text )
conPubs.Open()
intDeleteCount = cmdDelete.ExecuteNonQuery()
conPubs.Close()
lblResults.Text = intDeleteCount & " records deleted!"
End Sub
</Script>
<html>
<head><title>SqlFormDelete.aspx</title></head>
<body>
<form Runat="Server">
<h2>Delete Authors</h2>
<b>Last Name:</b>
<br>
<asp:TextBox
ID="txtLastName"
Runat="Server" />
<p>
<asp:Button
Text="Delete Author!"
OnClick="Button_Click"
Runat="Server" />
<p>
<asp:Label
ID="lblResults"
Runat="Server" />
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -