delete2.aspx
来自「《精通ASP.NET网络编程》附带实例」· ASPX 代码 · 共 45 行
ASPX
45 行
<%@Import Namespace="System.Data"%>
<%@Import Namespace="System.Data.SqlClient"%>
<Html>
<head>
<title>删除新闻</title>
<Script Language="C#" runat="server">
void delete_Click(Object sender,EventArgs e)
{
//当点击删除按钮之后执行下面的代码
SqlConnection MyConnection;
SqlCommand MyCommand;
String ConnStr;
//链接SQL Server数据库
MyConnection =new SqlConnection("Initial Catalog=mydb;Data Source=(local)\\NetSDK;Integrated Security=SSPI;");
MyConnection.Open();
if(newsid.Text==""){
Label1.Text="新闻的ID号不能为空!";
}
else
{
//删除记录
ConnStr="delete from news where id="+newsid.Text;
MyCommand=new SqlCommand(ConnStr,MyConnection);
MyCommand.ExecuteNonQuery();
Label1.Text="删除成功!";
newsid.Text="";
}
}
</Script>
</head>
<Body>
<Div Align="CENTER">
<P><FONT SIZE="+3">删除新闻</FONT></P>
<P>请输入要删除新闻的ID号:</P>
<form runat=server>
<asp:TextBox id="newsid" size="20" runat="server"/>
<br>
<asp:Button id="delete" onClick=delete_Click runat="server" Text="删除"></asp:Button>
<br>
<asp:Label id="Label1" runat="server"/>
</form>
</Div>
</Body>
</Html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?