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 + -
显示快捷键?