how to delete a row from dalalist through a button click

<asp:DataList ID="DataList1" runat="server" DataKeyField="ID" OnDeleteCommand="DataList1_DeleteCommand">
        <ItemTemplate>
            <asp:LinkButton ID="lnkDelete" runat="server" CommandName="delete">Delete</asp:LinkButton>
        </ItemTemplate>
    </asp:DataList>

protected void DataList1_DeleteCommand(object source, DataListCommandEventArgs e)
   {
       int ID = Convert.ToInt32(DataList1.DataKeys[e.Item.ItemIndex]);
       SqlCommand mySqlCommand = new SqlCommand("delete from tab2 where ID=@ID", con);
       mySqlCommand.Parameters.Add("@ID", SqlDbType.Int).Value = ID;    
       if (con.State == ConnectionState.Closed)
           con.Open();
       mySqlCommand.ExecuteNonQuery();       
       if (con.State == ConnectionState.Open)
           con.Close();
       DataList1.DataBind();
   }