初學者做網站

前端:

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
Width="844px" AllowPaging="True" DataKeyNames="Item_ID"
OnPageIndexChanging ="GridView1_PageIndexChanging" OnRowCommand="GridView1_RowCommand" >

<ItemTemplate>

<asp:Button ID="Button5" runat="server" Text="下架" />
<asp:Button ID="Button6" runat="server" Text="刪除" CommandName="Bdelete" CommandArgument='<%#Eval("Item_ID") %>' />

</ItemTemplate>

後端:

protected void GridView1_RowCommand(Object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Bdelete")
{
SqlConnection conn = new SqlConnection("Data Source=.;Initial Catalog=mydata;User Id=sa;Password=1234");
conn.Open();

SqlCommand cmd = new SqlCommand("Delete From Item_Detail Where Item_ID=@ID",conn);
cmd.Parameters.Add("@ID",SqlDbType.Int).Value=e.CommandArgument;
cmd.ExecuteNonQuery();

cmd.Cancel();
cmd.Dispose();
conn.Close();

mygDB();
}

}