📄 sqlformdelete.aspx
字号:
<%@ Page Language="C#"%>
<%@ Import Namespace="System.Data.SqlClient" %>
<script runat=server>
void Button_Click(Object sender , EventArgs e)
{
SqlConnection conPubs;
string strDelete;
SqlCommand cmdDelete;
int intDeleteCount;
conPubs = new SqlConnection( @"Server=localhost;Integrated Security=SSPI;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!";
}
</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 + -