📄 deletingdata.aspx
字号:
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<html>
<script language="C#" runat="server">
SqlConnection myConnection;
protected void Page_Load(Object sender, EventArgs e)
{
myConnection = new SqlConnection("server=(local);database=Northwind;Trusted_Connection=yes");
if (!IsPostBack) {
BindGrid();
}
}
public void BindGrid() {
SqlDataAdapter MC = new SqlDataAdapter("select * from Shippers",myConnection);
DataSet ds = new DataSet();
MC.Fill(ds, "Shippers");
MyDataGrid.DataSource=ds.Tables["Shippers"].DefaultView;
MyDataGrid.DataBind();
}
public void MyDataGrid_Delete(Object sender, DataGridCommandEventArgs e)
{
//删除的SQL语句
String deleteCmd = "DELETE from Shippers where ShipperID = @Id";
SqlCommand myCommand = new SqlCommand(deleteCmd, myConnection);
myCommand.Parameters.Add(new SqlParameter("@Id", SqlDbType.NVarChar, 11));
//设定用户要删除的记录
myCommand.Parameters["@Id"].Value = MyDataGrid.DataKeys[(int)e.Item.ItemIndex];
myCommand.Connection.Open();
try
{
//删除记录
myCommand.ExecuteNonQuery();
Message.InnerHtml = "<b>记录删除成功</b><br>";
}
catch (SqlException)
{
Message.InnerHtml = "无法删除记录";
Message.Style["color"] = "red";
}
myCommand.Connection.Close();
BindGrid();
}
</script>
<body>
<h3>清单</h3>
<form runat=server>
<ASP:DataGrid id="MyDataGrid" runat="server"
BorderColor="black"
HeaderStyle-BackColor="#aaaadd"
PagerStyle-HorizontalAlign="Right"
PagerStyle-Mode="NumericPages"
DataKeyField="ShipperID"
OnDeleteCommand="MyDataGrid_Delete"
>
<Columns>
<asp:ButtonColumn Text="Delete Employee" CommandName="Delete"/>
</Columns>
</ASP:DataGrid><br>
<span id="Message" EnableViewState="false" runat="server"/>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -